#How can I filter the posts based on a relationship attribute?

4 messages · Page 1 of 1 (latest)

near escarp
#

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

desert hatch
#

Querjes currently do not work on relationships

signal dragon
#

Instead of storing as a relationship you could store the user ID as a string attribute so that you can query by it.

proper flame