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.

As of now there is no direct way of doing so.

What's common is to:

1. Create another attribute named search
2. And then, create a function that will get trigger for each time the a document is updated in that collection.
3. Then, in that field you can concat all the searchable strings separate by empty space.
4. Apply Full text index on that field
5. 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