Server side Pagination

App Building
, ,
1

Could we have an example shown how the server side pagination works and is set up. I get suggestion in yellow showing

The data source currently has more rows than the page size.** With server-side pagination on, this data will not be displayed. Be sure to query for {{ table1.pagination.pageSize }} number of rows.

I have one example im trying to get working is Jira-
https://developer.atlassian.com/cloud/jira/service-desk/rest/intro/#pagination

But cant seem to work right, it dont show anything on page 1 but others it does but then very limited.

2

Hi @HMir! I recommend taking a look at the docs on the subject. They provide a good overview of how to implement server-side pagination for both SQL queries and API calls and displaying the resulting data in a table component. :+1:

3

Hello @HMir

First enable the server side pagination from the table

image
image330×590 18.9 KB

image

Now create the query for getting data using limit and offset

image
image551×874 44.1 KB

Use the total count of the data on the server side pagination:
image

On the change page run the query that we create :

image
image338×881 28.7 KB

Now its run perfectly.
Thank you.

2 Likes