Hi everyone, I would like to query data from a collection with a list of $id, but getting this error saying that the list of $id can only be 100. Is this a hard limit or soft limit? How can I solve this? or does this mean I can only divide the list of $id with 100 and does the query from collection for multiple times?
Soft. It's that params size constant here: https://github.com/appwrite/appwrite/blob/42eacd860ef3629608738c5f7b1c5f66ae140cfd/app/controllers/api/databases.php#L2986
Thanks for the reply, does this mean I will need to replace the init.php with volume attach?
Is this the correct path (/usr/src/code/src/app/init.php) to replace the init.php file?
Up to you. It's your instance 😜
[SOLVED] Error: Query on attribute has greater than 100 values: $id
Error: Query on attribute has greater than 100 values: $id
I have tried to update APP_LIMIT_ARRAY_PARAMS_SIZE in init.php, but it still shows the same error to me.
Recommended threads
- Query.search limitation
Since `string` is deprecated I used `varchar`, and now I cant use `Query.contains` , so I setup fulltext index and started using `Query.search` the issue is `Qu...
- function subdomain ssl certs
The generated subdomain isn't getting a valid ssl cert, I was wondering if appwrite automatically generates one or uses a wildcard for *.functions.domain.com? ...
- Searching by attribute "name" requires a...
I have a table "products" with a few columns I'm trying to search by, but I get this error: ```json { "message": "Searching by attribute \"name\" requires a...