Back
Increase the Limit for Querying Nested Relationships
I ran into problem when I upgrade my Appwrite self-hosted from 1.7.4 to 1.8.0. When I query election.position.candidates.votes, it doesn’t return any data. I found out that there's a limitation restricted only to 3 levels https://appwrite.io/docs/products/databases/relationships#limitations. I'm not sure if this changed in 1.8.0, but it was definitely working when I was using 1.7.4.
TL;DR
Issue: Querying nested relationships beyond 3 levels not returning data after upgrading Appwrite self-hosted to version 1.8.0.
Possible Solution: The limitation of querying up to 3 levels of nested relationships has not changed with version 1.8.0. Consider restructuring your queries to work within this limitation.
Did you upgrade your SDK?
I currently use "node-appwrite": "^20.3.0"
