appwrite and flutter query using or operator

Question

what I want to do is list all the documents in a collection lets say users collection where the user is in management or his salary is more than 2000 how could I do it

I have tried using queries yet appwrite creates the queries as an and operation

Answer 1

OR logic is unsupported at the moment. You will have to make multiple API requests for each OR condition and combine the data client-side.

FYI, here's the feature request for adding support for OR queries. I suggest adding a on the issue.