Hello, Appwrite team!
I'm having an issue with listDocuments when using query modifiers:
Environment:
- Self-hosted Appwrite (
Version 1.4.13) installed insideCaprover - Next.js (
node-appwrite@17.0.0)
Issue:
- The
listDocumentswithout any queries returns documents well - It fails when adding queries (even simple ones), I get 500 error
Example that fails:
TypeScript
const docs = await databases.listDocuments(
"db",
"recipes",
[
Query.equal("language", "en"),
Query.equal("status", "published")
]
);```
**What I've tried:**
Created indexes for all required attributes
Verified attributes exist in the collection
Tested with different query combinations
**Question:**
What could be causing queries to fail despite proper indexes? Are there special requirements for Enum attributes?
**Addintional DB Info:**
```json
{
"$id": "recipes",
"databaseId": "db",
"enabled": true,
"documentSecurity": false,
"attributes": [
"title",
"slug",
"description",
"prepTime",
"cookTime",
"servings",
"difficulty",
"authorId",
"tags",
"productIds",
"language",
"views",
"featuredImage",
"likes",
"status"
],
"indexes": [
{
"key": "status_idx",
"attributes": [
"status"
]
},
{
"key": "views_idx",
"attributes": [
"views"
]
},
{
"key": "createdAt_idx",
"attributes": [
"$createdAt"
]
},
{
"key": "status_views_idx",
"attributes": [
"status",
"views"
]
},
{
"key": "language_idx",
"attributes": [
"language"
]
},
{
"key": "status_createdAt_idx",
"attributes": [
"status",
"$createdAt"
]
},
{
"key": "language_status_idx",
"attributes": [
"language",
"status"
]
}
]
}
},```
TL;DR
Issue: `listDocuments` function with query modifiers is causing a 500 error despite having proper indexes.
Solution: Ensure there are no typos in the attribute names, and consider converting the Enum attributes to strings for compatibility.Recommended threads
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- Custom API domain is unreachable
Earlier my custom api domain was working fine. Now it seems to be offline without a trace a few hours later. I didn't change anything, all the relevant DNS reco...
- "Invalid console fingerprint" when unpau...
I've tried logging out and logging back in, still can't figure out why this is happening.