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
- I'm getting an error on the console "j?....
On my self hosted instance version 1.8.1 the console is giving me this error when trying to view the rows for a table I recently created. My application is read...
- Websites hosted on my appwrite sites hav...
Hello, all my websites hosted on appwrite sites are not running I am getting this message "This site canβt be reached drivehub.appwrite.network took too long t...
- Database Write Limits hit
Hello Appwrite Admins, I'm a GitHub Education user, and about a week ago, my database was really badly optimized, resulting in about 600k writes in a single day...