Back
[SOLVED] Query does not work on collections that has relationships with other collections
TypeScript
const res = await db.listDocuments(dbName, 'users', [
Query.equal('$id', [meta.$id]),
Query.orderDesc('recipients'),
Query.orderDesc('addresses'),
]);
console.log({ res });
This does not work.
recipients and addresses are separate collections that has relationship with users
I'm trying to be efficient querying users recipients and addresses but it seems I will need todo a separate query for recipients and addresses if I need to sort it.
TL;DR
The user is experiencing an issue with querying collections that have relationships with other collections. The user provides a code snippet where they are trying to query the "users" collection and sort by "recipients" and "addresses" which are separate collections with relationships to "users". The user mentions that this approach does not work and they would need to perform separate queries for "recipients" and "addresses" if they want to sort them.
Solution: The user is informed in a previous message that querying is currently not available in the beta version of Appwrite Relationships, but will be added in a later version. The user is directed to refer
You can read more here : https://appwrite.io/docs/databases-relationships#query
Well this url doesn't give any insights to my question
He is referring to the text: Querying is currently not available in the beta version of Appwrite Relationships but will be added in a later version.
[SOLVED] Query does not work on collections that has relationships with other collections
ok, thanks
