Rank 3: Container
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: 1998so 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