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
- How to implement - Invite only OAuth log...
I am working on a web app where users submit their email in the invitation page. OAuth should only allow signups from approved users. Existing users can sign-in...
- How to edit email template?
I already know that we can edit body of email templates in the console, but that still produces somewhat weird HTML output. Sometimes it looks broken in some em...
- How to implement password reset/recovery...
Good day everyone. I am using react native with expo. I want to implement deep link with the url recived via email. So when clicked the link it opens my app. I ...