My Server Code only returns the first 100 rows from the database

[mmeester@hotmail.nl]

Hello!

I made a script to read data and return part of this data based on a GET parameter. I use the standard

Code: Select all

var result = Collection.query("dbId", "collectionName");

to import my collection, but it only imports the first 100 rows of the collection. Can somebody please tell me how to import all (less then 50.000) rows?

[Oleg Solodiuk]

Hello,

You can control the limit of database rows per request by changing the parameter "limit", please see this link for more details: https://docs.appery.io/reference#databa ... pagination

[mmeester@hotmail.nl]

Awesome, thank you very much!