Hello there,
I've a post collection and each post has a relationship with the user collection. I was trying to fetch all the posts by a particular user by using this query:
const documents = await databases.listDocuments(
DATABASE_ID,
COLLECTION_ID,
[Query.equal("user.$id","userId")]
);
But I'm getting this error:
⨯ node_modules/appwrite/dist/esm/sdk.js (428:26) @ Client.eval
⨯ AppwriteException: Invalid query: Cannot query nested attribute on: user
at Generator.next (<anonymous>)
user attribute:
{
otherPostAttributes,
user: {
$id: "123",
name: "John Doe",
}
}
I would like to know how can I achieve this? Any help is appreciated. Thanks
TL;DR
Developers are unable to filter posts by a relationship attribute. The query to fetch posts by a particular user is producing an error. The issue seems to be that queries currently do not work on relationships.
Solution:
Consider redesigning the database structure to allow for more direct querying, or find a workaround until queries on relationships are supported.
