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
- TablesDB `updateRows` returns `database_...
Hi Appwrite team! I’m seeing a strange issue with TablesDB bulk row updates on a self-hosted Appwrite instance. **Environment** - Appwrite self-hosted `1.9.0` ...
- [SOLVED] Realtime Missing Channels
```js useEffect(() => { let subscription: RealtimeSubscription; async function loadChips() { try { const {rows: chi...
- Functions executed by events does not ap...
Hello, Running self-hosted Appwrite version 1.9.0 (with console 7.8.26). When functions are triggered by an event (eg. databases.\*tables.\*.rows.\*.create) doe...