Back

Different behavior between self hosted and cloud regarding querying relationship attributes

  • 0
  • Self Hosted
  • Auth
  • Cloud
Tomla
2 Feb, 2025, 17:18

I am wondering, what is true:

Here is stated, that queries of relationship attributes are not supported: https://appwrite.io/threads/1248091621074141214 https://github.com/appwrite/appwrite/discussions/7369 https://appwrite.io/docs/products/databases/relationships#queries

But I am using it since many month with appwrite cloud, and just realized that it is not working on my local machine using the self hosted version 1.6.0

Could you give an answer, what is the difference between cloud and self hosted regarding quering relationship attributes?

Example: One Module can have many Autonomylevels:

Modules [1] - [n] Autonomylevels

The same request causes different results on cloud an self hosted (V1.6.0):

Cloud: Request: https://cloud.appwrite.io/v1/databases/kicd/collections/autonomylevels/documents?queries%5B0%5D=equal%28%22modules%22%2C+%5B%2266130338758f1195f7cc%22%5D%29&queries%5B1%5D=orderDesc%28%22%24createdAt%22%29&queries%5B2%5D=limit%2810%29 queries[0]: equal("modules", ["66130338758f1195f7cc"]) queries[1]: orderDesc("$createdAt") queries[2]: limit(10) -> Response: 200 OK: works fine! 🙂

Local: Request: http://localhost/v1/databases/kicd/collections/autonomylevels/documents?queries%5B0%5D=equal%28%22modules%22%2C+%5B%22678841302ad6c9faa883%22%5D%29&queries%5B1%5D=orderDesc%28%22%24createdAt%22%29&queries%5B2%5D=limit%2810%29 queries[0]: equal("modules", ["678841302ad6c9faa883"]) queries[1]: orderDesc("$createdAt") queries[2]: limit(10) -> Response: 400 (Bad Request) Error: Cannot query on virtual relationship attribute

TL;DR
Developers are experiencing different behaviors when querying relationship attributes between the cloud and self-hosted versions of Appwrite. While it works on the cloud, the self-hosted version throws a "Cannot query on virtual relationship attribute" error. This discrepancy needs clarification from Appwrite regarding the differences in handling these queries.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more