
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
listDocuments
without 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
- Issue while signing up.
Hey, I’m running into an issue right after the setup. I followed the setup instructions and ran `docker compose up -d`, and while the local server seems to be r...
- Cannot resolve server
Greetings! Is this a known issue at this time? Cloudflare reports likewise. Please advise, thank you!
- Admin panel
