lucasOriginal post
Web Developer
Query.createdBefore doesnt work
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)
),
],
});
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
Summary
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`.