Supabase column search

asad

15 days ago

how can i search for a record based on a column in supabase using the api query parameters in toddle. i’m using pagination and only get 10 records at a time and need a solution that works with pagination
Armand

15 days ago

Have a look at this for pagination:

https://www.youtube.com/watch?v=8_QN70M8keU

For the search query parameter:

GET /rest/v1/YOURTABLE?select=*&COLUMN-NAME.ilike=%Xyz%

Note:
In caps is what you need to change for your table/column

The _ilike operator allows for case-insensitive pattern matching. But you could also do this in the formula and leave .ilike out of the query.

Xyz is the search value.

The % symbols are wildcards that allow for matching any characters before or after "Xyz".

Stop scrolling. Start building.