Database Service doesn't work

[Illya Stepanov]

Hi Ahmed - Please try to set and add 'limit' parameter, like codelimit=300/code it should return 300 entries.

[Ahmed bahaa]

Hi, it worked when i added the limit, but i think this just a workaround.. what if the number of records get bigger in the future(which i'm planning to do) .. do i need to set the limit again and make a new virsion of the app?

[Illya Stepanov]

If I'm not mistaken the real limit on one request is 1500. If over 1500 you can get it with several requests and by setting 'skip' parameter. So until 1500 you can use 'limit' parameter for sure.

[Ahmed bahaa]

1st: thank you for the support in solving this issue.

2nd: I'm not familiar with the process of (several requests) & (skip parameter), can you please add links to extra documents & resources about them?

thanks again for your time & effort

[Illya Stepanov]

Hi Ahmed,

Please follow this tutorial to understand how to work with limit and skip parameters. :: http://docs.appery.io/tutorials/build...

Also additional information: For list service default limit is 100 items (so by default without limit parameter service will return 100 entries).

Maximum limit is 1500 items - that was done to make impossible a long execution requests.

Regards.