Do you happen to be using GraphQL Relay cursor based pagination or just standard Cursor based pagination? If it happens to be Relay, could you try using regular Cursor based and see if that might be a workaround?
You also mentioned scrolling - do you have your table set to scroll as well?
I believe it is set up as Relay-based pagination, but I'm just using it like regular Curosr-based, I believe. I'm not too sure whether it is or not, since I'm using the Hot Chocolate GraphQL Pagination factory and it does it for me.
Here is an example of the response (with most data removed for brevity), followed by the settings used for the Retool table:
As you can see, I was using the Scroll option for Overflow, but Pagination does the same exact thing. The paging works fine at first (even going back and forth between pages), but if I go to page 2, and then trigger the datasource to refresh the data after a change, the table seems to think that it is on page 1, but shows the last 2 results, and won't let me go back.
Thanks for the additional context as well! We're looking into why relay-based isn't functioning properly on our side. And we can report back here when it's fixed.
To be clear, selecting GraphQL Relay-based in Pagination Type works for me, at least when I have the Overflow on Pagination rather than Scroll. My original issue was that I did not have Retool on Relay-based even though my server was doing it, because I simply didn't know what that was at the time.
The only remaining issue that I can see if that Scroll option still does not function correctly, regardless of what Pagination Type I use.
Got it, thanks for that clarification! We're looking to release a .refresh API for tables soon that should help give more control over when table pagination is reset that should help in both cases.