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
- Worker functions stuck on "Fetched 0 fun...
Appwrite Version: 1.9.0 Bug Description: The appwrite-worker-functions container gets stuck in an infinite loop logging "Fetched 0 functions..." while scheduled...
- I am using s3 for app storage but is it ...
_APP_STORAGE_DEVICE=s3 puts everything to the s3 storage but i need to be able to keep the function builds and site in the local and not waste the cloud storage...
- Local Serverless Function Testing: Are D...
I have followed the instructions to get the CLI working, and have been able to log-in, initialize my project, and created a simple Python function, which calls ...