Can someone please show me a clear stepped way of creating table pagination and setting the display limit

Wappler General
1

This lack of clear instruction to set up pagination on a table is so damn frustrating!

There are bits and pieces but they are old and seem to be different to the current interface.

I have created a paged query that is easy.

Two things to complete.

1, Using the bootstrap paging generated set up the pagination tool.

I see the tutorial here: https://docs.wappler.io/t/applying-dynamic-paging/2865

BUT, the server connect does not have the “Offset” or “Limit” options and not sure if this is an issue or the interface and process has changed?

  1. How do you them limit the number of records shown on each pagination and change with a drop down e.g. 10, 25, 50,
1 Like
2

did you by any chance change a multi or single query to paged if so you can either enter the variables in the get yourself or just add a actual paged query from the menu then delete it

Pass the value from the select into the sever connect limit

1 Like
3

@Sorry_Duh Actually I did change a multi to a paged query!

I see now that I add the paged query it adds the Get variables.

Now I get it!

I guess I was expecting the change to add what ever it needed to and didn’t check if it added the GET variables.

Thanks!

1 Like
4

Thanks @Sorry_Duh this fixed it!

1 Like
5

You might this “How To”
https://docs.wappler.io/t/applying-dynamic-paging/2865