We have a table that is showing there are 230 items, we are displaying 200 items at a time with pagination. When we click “Next Page” the table disappears and just displays “No items could be found”. If I increase the page size to 300 and export the table, I can see that there are 230 items total for the page to display. I’ve tried decreasing the page size to 50, and always when we try to access records after item 200 it displays “No items could be found”.
Hey @MWorth , it’s worth following up with our support team as @david said, but this can sometimes happen if you’re sorting by a field that isn’t fully filled.
This is unfortunately a weird edge-case with our database provider that we haven’t been able to track down.
One solution is to either sort by a different field, or add a formula field that makes sure that field isn’t empty, so if it’s empty you add a zero, or some text, such that the sorting behaves how you expect.
Our support team can provide better instructions if you share the details with them.