Table Server Side Pagination Issue

Hi All,

I’ve successfully set up server-side pagination, but I’m facing an issue with how the table interacts with user input. Here’s the scenario:

  • I don’t want the query to run on page load.
  • Instead, I want the query to execute only when the user clicks the Submit button after providing input.
  • However, when I make the API call manually, the pagination stops working as expected.

If i use pageInput with manual API instead of automatic to handle pagination manually, I’m unable to navigate to the next page. It always resets back to the first page.

I’m using Retool (self-hosted instance, version 3.148.2).

Has anyone encountered a similar issue or have suggestions on how to resolve this? Any help would be greatly appreciated!

Thanks in advance!

Got it, we were using same query to get data and page count so on each run the pageInput was getting reset to first page

1 Like