Paging

[fame.razak]

How can I implement paging? I have a REST service that only sends back 16 results at a time. How would I do this?

[maxkatz]

You would need to define a service that takes a parameter which defines which results to display next. You would probably need two things: 1) at which index to start, 2) how many records.

[Takis]

Hi

Can you explain a bit more?
What do you mean on which index to start?
Let say I have a table with 1000 rows.
I make a query with some criteria and it returns 500 rows, for example.

How I create paging of 20 records at a time, implementing next page, next page...?

Thanks!.

[Evgene Karachevtsev]

Panagiotis

Please look here:
http://devcenter.appery.io/documentat...

[Takis]

Hi Ευγενιε

The documentation says "To limit the number of objects you get, use the limit parameter."
I do not want to just limit my application to return the first 20 (based on my example above).
I want to retrieve the first 20 then press a button and return the next 20, and next...until I retrieve all records.

Thanks,

[Yurii Orishchuk]

Hi Panagiotis,

Here is two available parameters to make pagination logic:

"limit" - to limit query with items set in this parameter.

"skip" - to make offset to item set in this parameter.

Details: http://devcenter.appery.io/documentat...

We have good tutorial that will help you to understand how it works.
Please pass it: http://devcenter.appery.io/tutorials/...

Regards.

[Takis]

Thanks I will on it!

I do not know if is already exists, but it would be good if we can have a link with ALL the available tutorials and brief description.

[Takis]

Thanks I will look on it!

[Takis]

Sorry disregard previous question about list of tutorials.