imagine i have an attribute named hashtags which is string array of hashtags (ie, like twitter hashtags),
in query, i have to get all the docs which have "hashtag1" or "hashtag2" in its hashtags colum.
how to implement it ??
I think that you can use Query.equal(atrb, [...hastags])
[hashtag1, hashtag2] means hashtag1 or hashtag2
it does give empty result
Queries against arrays are not supported at the moment. Make sure to 👍 this issue: https://github.com/appwrite/appwrite/issues/2838
That said, there is a hack where you can create a full text index on the attribute and then use the search query.
But in that hack, only 1 keyword can be searched with a single query right?
There is no option to do "OR" on search.. right?
And why is the custom query option not yet available? It would give developers more freedom i guess
You can search space separated keywords.
Because Appwrite is supposed to be an abstraction over the underlying database
thankss.. that's what i needed
Recommended threads
- Error | general_unknown
I have built a website using Appwrite Cloud as backend, and also using sites for deployment. My website is live but sometimes it shows Appwrite's Error general_...
- Introducing new string column types made...
Adding new string types is hugely bennificial! Unfortunately it made the current column types not editable to change their types to the new longer field types.
- there is critical problem in this part
when user update the integer and double both get error not update or upload