Back
how can I search given string in multiple attribute of a documents and return the matching documents
how can I search given string in multiple attribute of a documents and return the matching documents. for example I have string "xyz" which could be present in attribute "cityname" or "countryname" . how can I list those documents which contains "xyz" either in "cityname" or "countryname".
Right now I am not able to find a way to find this. Please help.
TL;DR
To search a given string in multiple document attributes, you can create a new attribute to combine all searchable strings, apply a full-text index on that field, and then search it. Appwrite will support "OR" queries in version 1.5 to make this process easier.
As of now there is no direct way of doing so.
What's common is to:
- Create another attribute named
search - And then, create a function that will get trigger for each time the a document is updated in that collection.
- Then, in that field you can concat all the searchable strings separate by
- Apply Full text index on that field
- Search that filed and it will search over all the searchable attributes.
this is a common scenario. i thought there would be direct solution to it.
Appwrite will add support to "OR" queries in v1.5 and it will be released very soon. It will be possible to do what you're looking without any extra effort
thats so good to hear
