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

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?

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