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
- IMPORTANT! SOC-2 Request Failing
Issue requesting SOC-2. If tried other/private browser as well as filling in optional fields.
- Can you suppress row $meta data?
When using listRows with a 'select' query to limit the response [for performance], I'm still getting extra columns (eg. `$id`, `$sequence`, `$createdAt`, `$upda...
- CLI - get Database Totals
Is there a way with the Appwrite CLI to get table row totals (count)β