Skip to content
Start project
Back

Can I combine multiple full-text queries?

  • 0
  • Databases
View on Discord
42Tom
17 May, 2023, 14:00

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.
Vedsaga
17 May, 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
17 May, 2023, 14:04
Binyamin
17 May, 2023, 14:04

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

Yes, But only using AND logic

Binyamin
17 May, 2023, 14:05

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

42Tom
17 May, 2023, 14:08

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 🙂

joeyouss
19 May, 2023, 11:31

That's great to know @42Tom

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

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