
a small listDocuments in function keeps failing with 500
TypeScript
at Client.call (/usr/local/server/src/function/node_modules/node-appwrite/lib/client.js:174:31)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Databases.listDocuments (/usr/local/server/src/function/node_modules/node-appwrite/lib/services/databases.js:1638:16)
at async Module.default (file:///usr/local/server/src/function/src/main.js:14:24)
at async execute (/usr/local/server/src/server.js:141:22)
at async /usr/local/server/src/server.js:158:13```
the code
```const candidates = await databases.listDocuments(
process.env.DATABASE_ID,
process.env.CANDIDATE_COLLECTION_ID,
[
Query.select(['date', 'university', 'videos', 'regions', 'user_id', 'profile_image', 'status']),
Query.equal('status', 'accepted'),
Query.limit(PAGE_SIZE),
Query.offset(req.query.page * PAGE_SIZE)
]
);
log('Preparation list for '+ candidates.total)```
**note that dashboard showing random 500**
TL;DR
User is experiencing an issue with a small listDocuments function, which keeps failing with a 500 error. They are querying on relationship attributes and using the Appwrite cloud. User wants to know if others have experienced similar issues and if there is a solution.
Solution: The error seems to be related to a server error. One possible solution is to check if the code is correctly querying on the relationship attributes and ensure that the database and collection IDs are correct. It might also be helpful to contact Appwrite customer support for further assistance.
do you have relationships on this collection?

is this on Appwrite cloud?

it's on cloud yeap, there is a relation yeap

are you querying on any of the relationship attributes?
Recommended threads
- Upgrading Appwrite 1.7.4 → 1.8.x: What H...
I'm currently running a self-hosted Appwrite v1.7.4 instance that still uses the old Collections/Documents database model. I noticed that starting from v1.8.x,...
- File tokens regenerate each page reload
Hello, on appwrite 1.7.4, when I create a file token via the API Tokens(appwriteAdminClient)#createFileToken I get a secret, then when I check in the console t...
- CSV Import Shows Success but Data Not Ap...
I tried importing a CSV file into my PRODUCTS collection. The dashboard shows the message “Import to PRODUCTS completed successfully,” but no data appears in th...
