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
- AppwriteException: Invalid query: Query ...
```js console.log(typeof interaction.user.id) console.log(interaction.user.id) const user_check = await TablesDB.listRows({ databaseId: "db", ...
- Files access permissions
Am I right in understanding that file access permissions have been disabled (or broken again), and that shared access can now only be organized via tokens? Or i...
- functions custom domain issues in self h...
I’m running self-hosted Appwrite (Docker) behind Traefik with Cloudflare proxy (Full/Strict). Main domain works: https://app.printa4.in Function subdomains fa...