How to do query on `string array` attribute?? | Appwrite | Page 1

earnest mortar May 14, 2023, 2:29 PM

#

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 ??

gaunt slate May 14, 2023, 4:02 PM

#

I think that you can use Query.equal(atrb, [...hastags])

#

[hashtag1, hashtag2] means hashtag1 or hashtag2

earnest mortar May 14, 2023, 4:07 PM

#

it does give empty result

placid ore May 14, 2023, 5:19 PM

#

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.

earnest mortar May 14, 2023, 5:20 PM

#

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

placid ore May 14, 2023, 5:41 PM

#

You can search space separated keywords.

placid ore May 14, 2023, 5:42 PM

#

Because Appwrite is supposed to be an abstraction over the underlying database

#How to do query on `string array` attribute??