mmeester@hotmail.nl
Posts: 2
Joined: Sat Jan 09, 2021 7:32 pm

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

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
Posts: 36
Joined: Fri Jan 10, 2020 6:49 am

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

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

Return to “Issues”