How to implement the filter functionality provided in the Retool table for server-side paginated table?

[Aryan_Pegwar]

1. My goal: successful functioning of filters in server-side paginated table
2. Issue: I have recently migrated to a server-side paginated table because the table data that we are dealing with became huge. Earlier the filter functionality was working correctly but now the filters don't seem to do anything.

[ChiEn]

Hey @Aryan_Pegwar welcome back to the Community!

When server-side pagination is enabled, the built-in filter toolbar is disabled, it can only filter data already loaded in memory, not the full dataset. This is covered in the docs here: Filter data in the Table component | Retool Docs

Filters do not function if server-side pagination is enabled. Any filtering logic must be added to the resource query.

To get filtering working, you'll need to add filter logic directly to your backend query. If you'd like to keep the filter toolbar UI, you can follow the steps here:

Search Term Is Disabled for The New Table

Hi @Nasirullah It'll depend on your specific query/resource type, but you essentially have to create the filter within your query and return that filtered data with pagination. Here's a SQL example (I've disabled prepared statements to make this query work): [image]

Let me know if you need help setting this up!