Different behavior between self hosted and cloud regarding querying relationship attributes
- 0
- Self Hosted
- Auth
- Cloud
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
Recommended threads
- Sudden CORS Errors - Domain hasn't Chang...
I have an Appwrite project with two web apps configured, the first one has the hostname `*` and the second one I just added to test if it could fix the issue wi...
- User ID case sensitivity
I see that through REST (and SDK as well), getting a user is not case sensitive. And even though documentation does not clearly state that it is, the wording "V...
- Any way to temporarily bypass the email ...
Hey guys, any way to bypass the email verification to use the accounts again? i need to recover some projects that due to recent changes have been stopped, and ...