Hi everyone,
I have a collection in Supabase with around 3000 items. In Weweb, I created a collection connected to that database with pagination set to 10 items per page.
On the page where I display the paginated table, I’ve also added a search bar so users can search through the items. However, the search function only filters the 10 items currently shown on the page, rather than searching through all 3000 records.
Is there a way to configure the search so that it queries the entire Supabase dataset instead of just the items currently loaded in Weweb?
Thanks in advance for any help!
Yes, you can configure it this way:
Step 1:
Create a text variable, e.g., searchFingerprints .
Step 2:
Go to the Fingerprint collection (not the table) and add a filter that uses the searchFingerprints variable.
For example, if you’re searching by name:
name contains searchFingerprints, also toggle allow if empty
Step 3:
On your search input, create a workflow on input change:
First Action: Add a change variable value action to update searchFingerprints to the current input value.
Second Action: Add a Refetch collection action to reload the filtered data.
1 Like
Nice one Omotosho!
@Marike can you let us know if this worked for you?
Thank you very much!
Step 3 was missing in my set-up.
I’ve added the workflow and it works perfectly 
