Enable search term even with server side pagination

💬 Feature Requests
1

I had a table with search set-up and after I while, I added server-side pagination to it. Then I noticed that the search feature disappeared from the Table inspector. After reading the Table docs for the 42nd time, I didn't saw any explicit mentions for this absence :smiling_face_with_tear:
After tweaking around I saw that the feature would reappear :ghost: if I disabled server-side pagination...
Then I read this post Search Term Is Disabled for The New Table.

I'm not sure why the search feature would be completely disabled, but:

  • when adding logic to disable a feature, it would be awesome to display it in the inspector and also explicitly mention it in the docs please :pray:. This would save a lot of time and energy :slight_smile:
  • I have server-side pagination, but I still want client-side search and filtering option. At least for a while, and in order to maximise Retool usefulness. I think a warning would be better than completely disabling the feature
  • I then saw that filtering options were completely disabled Filter table with Server-side pagination enabled. Again, it's not very clear, as my table still has the option activated, but the feature doesn't do anything

Thank you and happy new year!

1 Like
2

Hey @seb, thank you for sharing that feedback! I went ahead and shared that with the team and filed a request to keep track. If we have any updates we will share them here.

3

Any updates on this? This is a real pain for us as well

4

Can anyone share if there's a workaround for this?

5

I don't believe there is an existing workaround at this time. This is still in our backlog, but I will add your plus 1s to the existing request!

6

Hey @seb

You can use the dynamic query for the getting search in server side pagination of table.

Follow the steps:

Create the table and search(text input) in retool :

image
image727×518 27.3 KB

Use server-side pagination query in it :

image
image516×878 49.7 KB

Enable server-side pagination in a table :
image

On table event handler trigger query on change:
image

On the search bar, the event handler triggers the query on change :
strong text

image
image1050×602 57.5 KB

3 Likes
7

Thanks for sharing!

8

helpful but only really works when you have a relatively small number of columns. I have this issue on a table with 20+ columns and i cant slap a wildcard search on every single possibility without destroying the time it takes the query to pull, Which is the whole reason I need to use serverside pagination in the first place.