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

Moderator: Support

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

Post 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?


Oleg Solodiuk
Posts: 30
Joined: Fri Jan 10, 2020 6:49 am

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

Post 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


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

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

Post by mmeester@hotmail.nl »

Awesome, thank you very much!


Post Reply