I have this code (also attached image): const getAllUserOrders = databases.listDocuments(process.env.DB, process.env.DB_ORDERS, [ Query.equal("userId", userId), Query.equal("status", "active") ])
And i want the Query.equal to retrive either "active" or "expired"
How can i achive this?
You'd do Query.equal("status", ["active", "expired"]), arrays can be used to specify multiple values in some queries
thanks I'll try that
Recommended threads
- Realtime Error Invalid query: Syntax err...
I was test driving Self-Hosted Appwrite for my use with Swift IOS apps as a backend while back and after successful trials, I started to move to incorporate int...
- listRows result parsing issue
I'm using Appwrite Dart SDK "24.2.0". When I perform a listRows call in dart, I have this reponse in JSON: in " Future<models.RowList> listRows()" { "total" :...
- Index for combination of columns
How am i suppposed to apply index so that combination of two columns alwasy remain unique in appwrite table though console