As per the doc, we can search only one keyword in an attribute with the Query.search method. but I have an array of keywords, and I want to check if any of the keywords are present in the attribute. how can I do that?
Maybe it'll be a good idea if I explain my scenario a little more. I'm working on a car buying-selling marketplace. so each car has a Model, Engine, Color, Manufacturing year, etc. I wanna implement a search functionality where the user can combine anything they want to search a car. i.e. they can type "Volvo Blue", and the search functionality should return all the Volvo cars with Blue color. so to implement that, I can't query any specific attribute. so, what I'm thinking, is to store all the attribute values in a single attribute, maybe named "search_queries". i.e. if a car schema is
brand: "Volvo"
model: "A3"
color: "Blue"
manufacturing_year: 1998
so the search_queries attribute will look like
search_queries: "Volvo A3 Blue 1998"
so that I can only search the search_queries attribute for any searched keyword.
To do that, I need to pass an array of keywords in the Query.search method because the user can type a long string (I'll make an array out of it, separated by Space)
So can you think of any other solution for my issue?
Stack: NextJS@14 Appwrite: Cloud
lmk if u need any further info
Pass one string with keywords separated by spaces
will it work? won't it consider the whole string as one keyword?
Yes, it should work. No, it won't be considered one word.
tried it. and it worked. thanks
can i do Query.search with multiple keywords? [SOLVED]
[SOLVED] can i do Query.search with multiple keywords?
Recommended threads
- [SOLVED] Appwrite Cloud and FRA cloud se...
Can anyone estimate how long this will take to resolve? I am checking status here https://status.appwrite.online/
- How to use Operator.arrayAppend on a rel...
Hi, is it possible to use any operator on a relationship column? I have a One to Many relationship column on a table and I would like to add entries to the colu...
- Terraform tablesdb_column type inconsist...
Hi, I am trying out the new terraform provider for appwrite that was introduced a few weeks back. As a first step I wanted to import our existing databases into...