External Paging
Using Simple Mode for external paging, you can easily set variables or values for the following options as pertains to paging:
Page
The current page of results
Per Page
The amount of results per page
Offset
Offset is available if you need to manually define an offset for the set of records returned.
The following example, assuming your record IDs start at 1, will return records 1 - 10:
Page: 1
Per Page: 10
Offset: 0
The following example, assuming your record IDs start at 1, will return records 2 - 11:
Page: 1
Per Page: 10
Offset: 1
To define your external parameters using simple mode, just specify your desired values or variables in the External tab:
External tab
External is the section where you can enable external override for sorting, filtering, and paging of your data. External override means you can enable your front-end to override how your data is filtered, sorted, and paged.
For more information about paging, including Classic Mode, see our full documentation at: https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-paging