Firebase Flutter - Request with multiple where arrayContains

Question

In my firebase documents, I have a field named "tags" that is a List, for example tags = ["Amazing", "Great", "Disappointing"].

I want to filter the documents to query, so the user select a list of tags, for example filteredTags = [Amazing", "Great"]. In my request, I want to retrieve all documents that have all elements of filteredTags in there tags list.

This query does not work because it looks for a list within tags, which is just a list of string :

query = query.where(KeyTags, whereIn: filteredTags);

And this query return an error, because flutter does not allow to have multiple arrayContains in the same query (works if I have only 1 tag in filteredTags list) :

for(dynamic tag in filteredTags){
    query = query.where(KeyTags, arrayContains: tag);
  }

Finally, this one work but is not what I look for (it retrieves documents that have one of the filteredTags, whereas I want documents that have all of them :

query = query.where(KeyTags, arrayContainsAny: filteredTags);

Any idea of how to do it ?

Thanks !

Frank van Puffelen · Accepted Answer · 2023-01-14 16:14:30Z

2

What you're describing is an arrayContainsAll type operator, which doesn't exist at the moment.

The only way to implement this now is to store the tags as a map with subfields for each tag and then a value, and then query for those values with equality checks in your query. For example:

tags: {
  "Amazing": true, 
  "Great": true, 
  "Disappointing": true
}

And:

query
  .where("tags.Amazing", isEqualTo: true)
  .where("tags.Great", isEqualTo: true)

Also see:

answered Jan 14, 2023 at 16:14

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LearningPath Over a year ago

Important to underline that user will be limited by the number of index to create for each combination :(

Collectives™ on Stack Overflow

Firebase Flutter - Request with multiple where arrayContains

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related