Page 1 of 1

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

Posted: Sat Jan 09, 2021 7:37 pm
by 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?


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

Posted: Sat Jan 09, 2021 8:26 pm
by 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


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

Posted: Tue Jan 12, 2021 12:27 pm
by mmeester@hotmail.nl

Awesome, thank you very much!