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
- Oauth issue
Hi, can anyone help me in the Oauth issue, Its working fine in dev but its showing Invalid redirect during production. I have check the redirect url and all. St...
- Google/Apple OAuth to show continue to "...
hi everyone, I am building a react-native app with expo and appwrite. I have setup an OAuth flow with Google and Apple following this doc (https://appwrite.io/b...
- Which flutter SDK version for Self Hoste...
Hi all, Is there a good way to figure out which version of flutter SDK and Dart SDK is current for latest available self-hosted 1.8.0 ? I know new features are...