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
- Weird permission failure
when creating an account I use following methods: ``` Future<void> register(String email, String password, String username) async { final user = await accoun...
- Relation Question
How do I create a relation from table y to an others x.$id. in my example I have a users table where I use Appwrites unique User IDs and I want other tables fo...
- Unknown attribute type: varchar / text
Since the `string` type is deprecated I tried using `varchar` and `text` in some newer tables, but when running `appwrite pull tables && appwrite types ./src/li...