How to create a Simple Search in FlutterFlow using Supabase!

[@beepypeepy]

I love how you get vaguely more pissed off as the tutorial goes on. More tutorial youtubers need to let their emotions show. this was very helpful btw thank you

[@beepypeepy]

Would love that fix for returning a single item if anyone figured it out. thanks

[@DavidShort1]

Hey i was running into problems similar to yours and realized that the Query Parameter was not needed and interfered with the query. That was my experience, anyway. Great video! Thank you for sharing this information!

[@Leakhorn]

I valid. I spent hours there before finding the problem.

[@moritz6856]

Same problem here :D 2 hours until I saw your comment hahaha

[@ameilsheridan1557]

my fellow victim of query paramaters hahaa

[@corbantwilley5861]

oof, I've been working on this for so long, so glad I saw your comment lol

[@Cesarkzz]

thanks!! it took me 10 minutes thanks to you

[@erikgotz595]

Amazing video, it worked perfectly for me! Did you write the fish data yourself or did you gather it from the internet? I'm trying to build a comparison app for fish, so it would be helpful to have some data to start with.

[@PorygoneLabs]

Great!!, thank you so much, worked perfect for me and I was searching to do querys this way instead the supabase integration within FF.

[@julienfernandes5665]

To work with a single result, what you need to do is replace the JSON path entered manually to filter the results, with a JSON path that you enter manually in the flutterflow api after testing api results, and don't forget to check the "is list" box.

[@beepypeepy]

can you please elaborate on what you did? I am still not able to get this to work. Thank you.

[@RaycelGraterol]

Thanks you so much hey men to avoid URL encoding you can use * as an alias of the percent sign % for the pattern

[@HelloBeach-m1m]

Bro ... Thank you! I've been trying to figure this out for a while. Any idea on how to search for something based on the users location and category? My specific scenario: the user is logged in, zipcode is in DB, when they go to search for a category, I want to display results based on their location. ( Ex. User is looking for stores nearby to buy a specific fish type) not sure if I have to have two search fields or if I can get the location from DB and display filtered list.

[@ethanprince9]

Where I filter by id is present in ID, you can filter by Authenticated user zipcode is contained in database zip codes. Can use my search filter of ID, and add a second filter of zip code, with both filters, it should work as you expect.

[@HelloBeach-m1m]

Thanks again. I wasn't able to figure out visibility with two variables but I was able to do this.

[@addict85]

Great stuff, man! I'd also be interested in seeing how you were able to implement the collapsible scroll on your details page. I have a similar detail page setup as yours (general buttons/options up top, an image, basic info, tab view). Right now on my app, everything down to the basic info stays stationary, but it looks like you figured out what seems to be a two-part collapse feature (image collapses first, then basic info collapses upon further scrolling).

[@Abaybay4u]

To get rid of the error you have to use a condition to check if the json body is not null and reload the backend if it’s not empty that’s will fix the problem or the error it worked for me

[@Gab-mf6xq]

I am having the same problem. it is weird, what I am searching is there but depending on what part of the word I am using will determine the success of the search.

[@HelloBeach-m1m]

So 1 finding to help with "exact" text search. I set mine to follow your directions, however since I can't figure out how to do this with many to many joins ( I need to break things down by state, city, category and GIS, based on user input). I actually just created a column with multiple values in comma separated form and although it's not the most efficient on the DB side, I'm able to type pretty much exact. I've a pretty large DB that I need to do m2m joins, if you or anyone figures it out... that'll be amazing!

[@olliewarren2075]

If I want to do this with users, what parameter would i need to pass to load user information?

[@joshuaw6976]

Hey great video, Im building a similar app on flutterflow with listview. How do you get selectable items in your list view? After creating dynamic children, I can't assign any container to a different page? How were you able to click on an item and go to that page from listview?

[@blackdash225]

how would the url look if i wanted to use "match at least one filter"?

[@danzreview]

awesome bro

[@josucafd]

Here for me it returns "200", but always empty

[@ethanprince9]

There must be something up with your search terms, that indicates that you contacted the API correctly, but nothing matched your search.

[@tomazstarasinic2081]

It is the same for me, always just 200 and []. Don’t know why. Copied some select id from api documentation on Supabase and is not working.

[@emeriktremblay3881]

pretty sure that you are missing a policy on your supabase table, classic mistake

[@richardsloan9395]

Would love if this worked for returning a single value as opposed to just multiple.. anyone got any ideas?

[@richardsloan9395]

never mind, figured it out.

[@beepypeepy]

@@richardsloan9395can you share how you got it to work? Thanks

[@StormK7]

​@@richardsloan9395How??

[@DanVanDamme]

@@richardsloan9395care to share?

[@wavepicturesfilm]

@@richardsloan9395 How did you figure it out?