Server-side configuration of the default query result size limit?

vasiliyzukanov · September 1, 2022, 2:49pm

By default, all queries have a limit of 100 on the returned collection size. This limit can be changed by invoking query.limit(<some number>) in JS or analogous methods in other SDKs. That’s great, but cumbersome and error-prone.
Is there a way to change the default limit of 100 on the server side, such that it will apply to queries from any client?

davimacedo · September 5, 2022, 4:31pm

There’s a Parse Server option called maxLimit that you can use to set that.

vasiliyzukanov · September 6, 2022, 7:03am

Unfortunately, maxLimit is a different feature, so it looks like what I want to achieve isn’t supported yet.
I opened an issue in GitHub for a new feature (approved) and submitted a PR. Will appreciate if anyone could assist me in merging it.

github.com/parse-community/parse-server

Configuration option to change the default limit on the size of query result collection

opened 08:41AM - 04 Sep 22 UTC

vzukanov

type:feature

### New Feature / Enhancement Checklist  - [ x ] I am not disclosing a [vulnerability](https://github.com/parse-community/parse-server/blob/master/SECURITY.md). - [ x ] I am not just asking a [question](https://github.com/parse-community/.github/blob/master/SUPPORT.md). - [ x ] I have searched through [existing issues](https://github.com/parse-community/parse-server/issues?q=is%3Aissue). ### Current Limitation By default, all queries have a limit of 100 on the returned collection size. This limit can be changed by invoking `query.limit(<some number>)` in JS or analogous methods in other SDKs, but this approach is cumbersome and error-prone. I think that giving Parse-Server users an ability to change the default limit on the server side would be great. ### Feature / Enhancement Description Additional startup configuration option that changes the default query result size limit. Proposed name: `queryResultSizeLimit` ### Example Use Case ``` parse-server \ --publicServerURL https://domain/parse \ --appName app \ --databaseURI mongodb://localhost:27017/app \ --appId appId \ --queryResultSizeLimit 10000 ``` ### Alternatives / Workarounds The current workaround is to change the limit manually in all queries on the client side. If there are multiple clients, all of them need to perform these changes. ### 3rd Party References