Hello,
Is it possible to query multiple fields with full-text indexation?
For example, I want to search "Adidas" in a collection of sneakers, and return both sneakers which name or brand match.
A dirty solution would be to create and index a new field with both terms, but not ideal.
Also, can I query the content of a relation? (Find sneakers where sneaker->brand->name matches "Adidas")
Summary
The user wants to know if it is possible to combine multiple full-text queries and query the content of a relation. The response is that it is only possible to combine full-text queries using AND logic. However, querying the content of a relation is currently not supported. The user also shares that they have chosen Appwrite as their default backend for their dev agency. No solution is provided for the query limitations.
Vedsaga
Rank 5: Hypervisor
May 17, 2023, 14:03
Also, can I query the content of a relation? (Find sneakers where sneaker->brand->name matches "Adidas")
Unfortuently that is not supported yet
Vedsaga
Rank 5: Hypervisor
May 17, 2023, 14:04
Binyamin
May 17, 2023, 14:04
Is it possible to query multiple fields with full-text indexation?
Also, happy to tell you that after a few months following Appwrite's development I finally chose it as our default backend for my dev agency. Currently creating our first production-ready app 🙂