Hello everyone!
I’m having an issue with pagination in a repeating group and I’m wondering if anyone has run into something similar.
I have a page with search filters and a repeating group that returns data based on those filters. The data is fetched via Data API (SQL Database Connector) using LIMIT 100, and I’m handling pagination manually using an offset.
Here’s how it works:
- The repeating group always shows 100 records per page.
- I have 10 pages in total, and the “Next” and “Previous” buttons update the offset correctly.
- When no filters are active, pagination works perfectly — changing pages updates the data as expected.
But the problem starts when any filter is applied:
- The first page loads the filtered data correctly.
- But when I click to go to the next page, the data doesn’t change — it shows the same records, as if the offset is being ignored or reset.
I’ve already reviewed all the workflows and custom states, and the offset seems to be passed correctly. I suspect there might be a problem with how offset interacts with filters, or maybe the filters are being reset/ignored when switching pages.
Has anyone experienced something like this or has any idea what I might be missing?