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?
TL;DR
The user wants to know how to retrieve both "active" and "expired" values using the Query.equal function in a database query. They have provided a code snippet where they currently only use the "active" value.
A possible solution is to pass an array with both values to the Query.equal function.
Example: `Query.equal("status", ["active", "expired"])`