I was using Appery to store some historical test data in a table (1041 entries). I wrote a test program to read the data and drive load from my browser to another system. Yesterday my database list service returned all 1041 entries. Today it only returns 100. Was the query limited? Are large return sets problematic?
I suppose I could get smart and just put this static data in a data structure in a file and pull in just like another .js file rather than using the database.
Hi William,
Please check, do you have a request parameter 'limit'?http://docs.appery.io/documentation/b...
I was using the standard __list_service which doesn't have any parameters. Like I said, last night it returned the whole collection, this morning it only returns 100. No code changes.
So I experimented and if I do a curl command without a limit, it is limited to 100 (tried on two tables 100 entries).
If I add:
-G --data-urlencode 'limit=1'
It returns ALL the records.
and just for fun, if I add:
-G --data-urlencode 'count=1'
It returns the count as I would expect.
I could privately e-mail you the curl commands I am using if you want.
William,
We are sorry, there is a bug with 'limit' parameter. Will be fixed asap.
We'll ask our developers about 100 records limitation and update.
Hello!
1) 100 - is a default value for everyone
2) you can set any value you need
3) the max value you can set is 1500, please let us know if you need more
Sure, today I noticed this change as well. I had to set 'limit' in some services. It took me some time to detect this 100 records new default policy. I think developers would like very much to be notified somehow of structural changes like that, because it affects Apps already in production. In my case, a user told me about the bug and I had to hurry up to fix it.
At least the fix was quick.
This is just developer a feedback.
Hello! Thank you for the feedback! I'll check what we can do here..
Hi!
In the music shop APP with the new model and storage, I add 106 elements to the instruments collection..
In the list service, on the catalog screen..,,it returns only 100 elements,,,I didnt set any limit, its a plain list service..
what should I do to return all the 106 or more elements??
No errors in console...
this happens both on browser and device..
Regards
Hi Alex,
This is default limit, you can customize it, please read here http://devcenter.appery.io/documentat...
update: I add limit 1500 to the Request, and now its returning all the items in the DB..
Regards