Refreshing a table doesn't reapply the search filter term

App Building
1
  • Goal:
    I have a search filter that applies as a search term on a table. I have an update form that updates a row in that table. On the update api call I have a success handler that does the table.refresh(). I then often see a random row rather a reapplication of the search term keeping the same one row, now updated, that the search term found before.
2

Hey @James_Irwin ,
Welcome to the Retool community!

I understand the issue you're facing. You can resolve it by using either a transformer or JavaScript code to apply sorting on any field, such as by timestamp in descending order or by name in ascending order. This approach will ensure consistent sorting, so when you call the update query, the issue of a random row appearing will be resolved.

1 Like