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
- total parameter not working correctly in...
Hello Appwrite team, I'm experiencing issues with the total parameter in the listRows() method (TablesDB) across multiple SDKs. **Issue 1**: Node.js SDK (node...
- Free plan Usage
I using a free plan with one organization. I have three projects but on the free plan I should be able to have 2 projects running But in my case only 1 out of ...
- Database AI Column Suggestion Use Case
I tried using the AI column suggestion feature. For me, I prefer writing my column design separately in a notepad. Then my intention is to paste it into the AI ...