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
- Site deployment keeps getting failed
Hi good folks, need a hand with Sites deploy Error on every deploy: Synchronous function execution timed out... duration doesn't exceed 30 seconds [exact log ...
- Relation Question
How do I create a relation from table y to an others x.$id. in my example I have a users table where I use Appwrites unique User IDs and I want other tables fo...
- Unknown attribute type: varchar / text
Since the `string` type is deprecated I tried using `varchar` and `text` in some newer tables, but when running `appwrite pull tables && appwrite types ./src/li...