
Basically I have four collections.. and each collection is related in a linear order.. now the problem is first collection's relation attribute is there in document data fetched .. same for first to second collection relation attr but after that second to third relation attributes are missing.

_ _ is there a limit ? do i need to refetch the documents from 3rd collecion so i can directly get relation attrs

Please make sure to read the docs:
https://appwrite.io/docs/databases-relationships#limitations

thanks for sharing.. i understand the docs are important but i miss the stuff in some cases (like the limitations part was at very last)

the doc link references are really helpful

so i am guessing the best solution is to get the document right after 3rd level?

That would work
Recommended threads
- How to reduce DB Reads?
I just noticed that I hit the 500k db reads limit on my very small next js app with the most data being present in one collection having around 50 documents. ...
- Getting issue while migrating from Self ...
i try to migrating my project but when do this error come and dont allow to crate that migration
- Fail to receive the verification email a...
I added my email address to prevent it from showing "appwrite," but now I'm not receiving emails for verification or password resets. The function appears to be...
