Query.createdBefore doesnt work
TypeScript
tables.updateRows({
databaseId: process.env.APPWRITE_DATABASE_ID,
tableId: process.env.APPWRITE_TABLE_ID,
data: { indexed: true },
queries: [
Query.and(
Query.equal("indexed", false),
Query.createdBefore(maxRowCreationDate),
Query.limit(1000)
),
],
});
TypeScript
TypeError: queries.map is not a function
at _Query.and (file:///usr/local/server/src/function/node_modules/node-appwrite/dist/query.mjs:286:61)
at Module.default (file:///usr/local/server/src/function/src/main.js:170:17)
at async execute (/usr/local/server/src/server.js:220:16)
at async action (/usr/local/server/src/server.js:237:7)
at async /usr/local/server/src/server.js:26:5
even using Query.lessThan("$createdAt", date) outputs AppwriteException: Server Error
TL;DR
Developers are facing issues with `queries.map is not a function` when using Query.and in their code. Even using Query.lessThan results in a `Server Error`.
Solution: In the code snippet, instead of `Query.and`, try using `new Appwrite.Query()` to create a new query instance. This should fix the issue with `queries.map is not a function`.Recommended threads
- All My Project is Gone
Hello everyone, please help. Why have all my projects suddenly disappeared? I received a warning via email about one of my projects being paused. When I clicked...
- > AppwriteException: The requested servi...
When trying to read or write from my database I get the following error: > AppwriteException: The requested service is disabled. You can enable the service from...
- 500 Server error
getting same 500 status This is my appwrite project: https://cloud.appwrite.io/console/project-fra-691932db0036241caa0e/overview/platforms Help how to open th...