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
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- executeFunction intermittently throws Fo...
Environment: Flutter app using the Appwrite Flutter SDK, calling executeFunction for [describe endpoint, e.g. live-stream-related function]. *Description*: Int...
- Console display all Databases as TablesD...
While looking at an issue with <@1231860789355347971> we saw that the console was displaying ALL databases as `TablesDB` even if the real type in the API is `le...