Search and filters

Technical Help
1

I’m looking to setup a search filter using my Baserow project tables as the backend.

In the API I don’t see an option for searching through the database.

I want to allow people to simple search for the institution of choice and filter based on country, city, type

I’m integrating with flutterflow my the way. Looking to setup a front end where the user can simple search or filter based on criterial shown.

What’s the syntax for the filter…it’s not clear in the API doc. And how do I search up only items searched for to show.

image
image1266×722 83.4 KB

1 Like
2

Hello @hcraige, have you seen this post: How to search via API?

3

Hi,

You can check the API docs for a specific database by clicking the three dots next to your database name and selecting “View API Docs”.
image

Next, select the table where you want to apply a filter on and scroll in the documentation until you see the “List rows” section. This sections lists all parameters that can be added to the querystring. Also the filter:

image
image1332×526 121 KB

For example: you want to see all the records where the country is Saint Lucia:

https://api.baserow.io/api/database/rows/table/[id of your table]/?user_field_names=true&filter__field_[id of your field]__equal=Saint%20Lucia)

If the filter does not work, it is in my case mostly because I made a typo with the double underscores between filter and the field name or the field name and the actual filter.

Tip: I am not very familiar with Flutterflow, but it is a good practise to use a tool like Postman to test your queries.

Regards
Frederik

3 Likes
4

Hi there! Is it possible to add a search button to a table in Baserow app, or to implement column filters in the app?

5

Good morning @DonKelly, please see your other post for more information.

6

I will appreciate a video to explain this. I couldn’t understand how to do it.

7

I’m looking something like this that allows public to search items:

chrome_iABYg9O881
chrome_iABYg9O881515×530 23.3 KB

8

I am not sure if I completely understand your question. Do you want to make an API call to search items in an external mobile application through the API?

9

Thanks for your answer. I’m in a basic level and my English is poor. I will try to understand firt what an API is. I’m very happy with baserow but I try to have a “searching” function on top of the list but I didn’t find it. I read that this function is not available yet.