Can I combine multiple full-text queries?

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")

TL;DR

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.

Also, can I query the content of a relation? (Find sneakers where sneaker->brand->name matches "Adidas")

Unfortuently that is not supported yet

Is it possible to query multiple fields with full-text indexation?

Yes, But only using AND logic

You can see more details here https://discord.com/channels/564160730845151244/1108179606680383508/1108205828894375956

Great, thanks for the quick response!

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 🙂

That's great to know @42Tom

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support