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
- MongoDb Database Breaks integer[] & bigi...
I've got a table with the below column created. When I try to insert the value `[-3408048000]` into it, the dart sdk cloud function call is successful (no error...
- 1.9.6 Console handles all array columns ...
When creating or updating a row in the appwrite 1.9.6 web console, the form treats all list columns as a type string. Even if the column is a list of booleans, ...
- Temporary $permissions hickup?
Hello, today at ~13:50 (CEST/UTC+2) our customers reported they couldn't see any data in our application. We checked and indeed, the application was working, bu...