[SOLVED] Issue with Selecting Attributes within Nested Collections in Query Select

Hello, I was able to select attributes within Collection B using 'Query. select' within a relationship with Collection A. However, I am encountering an issue with selecting attributes within Collection B after adding a third level with Collection C. The relationship now looks like Collection A -> Collection B -> Collection C, and I'm unable to select attributes within Collection B.

yes, there is limited support for select at the moment. make sure to upvote this issue: https://github.com/appwrite/appwrite/issues/5376

Thanks, but that's not the same as my issue

What exactly are your collections and what are queries in your request?

I have four collections: userPreview, userData, post, and review. UserPreview has a one-to-one relationship with userData and a one-to-many relationship with review. Post has a one-to-many relationship with review.

Currently, I am querying the review collection (using the post ID index) and receiving a response that includes userPreview and userData. However, I do not want userData, so I tried using Query.select on userPreview, but it doesn't seem to work. It only works when I remove the relationship between userPreview and userData.

that sounds like the 4th task in the issue, right?

Yes,

right, so make sure to 👍🏼 the issue

Alright, sure

[SOLVED] Issue with Selecting Attributes within Nested Collections in Query Select

It seems to work now after I removed the relationship between 'review' and 'post'. It appears to me that 'Query.select' doesn't work on a document that has two relationships within it.