LysineOriginal post
Rank 1: Thread
I was trying to list rows in a table that do not already exist in another table. I retrieved around 260 row IDs which are 13 characters in length each, and then used Query.notEqual('$id', rowIds) to query the target table. However, I received this error:
AppwriteException: Invalid `queries` param: Value must a valid array no longer than 100 items and Value must be a valid string and at least 1 chars and no longer than 4096 chars
code: 400,
type: "general_argument_invalid",
response: "{\"message\":\"Invalid `queries` param: Value must a valid array no longer than 100 items and Value must be a valid string and at least 1 chars and no longer than 4096 chars\",\"code\":400,\"type\":\"general_argument_invalid\",\"version\":\"1.8.0\"}",
In my opinion, a character limit of 4096 is way too limiting for any non-trivial queries like this one. I would like to see the database being able to at least handle 500-1000 IDs before throwing the same error.
Summary
Developers find the maximum character limit for query params to be too restrictive when making certain types of queries in the database. The error message indicates a limit of 4096 characters, which is causing issues when trying to query with 260 IDs. The developer suggests increasing the limit to be able to handle 500-1000 IDs without errors. Solution: The developer requests the database to handle a higher number of IDs without throwing an error.