I am trying to fetch documents from a collection and the query looks like
Query. Equal('Attribute 1', value), Query. Equal('Attribute 2', value2), Query. NotEqual('Attribute 3', List<String values>);
Documentation says it should work. What am I missing ?
Passing an array makes it an OR. So you're doing attr3 != val1 OR attr3 != val2 which would always be true
Ah you are right, did not think it through. Any way to craft it so its "AND" since the list would be dynamic list of document ids ?
Every query is AND'd with each other so add a separate query to the queries array
Trying something but just so I dont end up wasting too much time on something dumb, I am planning to create a queries array List<String> and loop through document list I dont want and will add a NotEqual query in that queries array. Is that the idea ?
Worked .. Thanks
[SOLVED] NotEqual queries require exactly one value (error 400)
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...
- 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...
- HTTP Error 500 ''
Hello to everyone, I'm a Flutter developer and actually I'm developing an app using Appwrite.. during my tests and also massive ones I've noticed something we...