Flutter Firestore where clause using map

Question

When a new activity is posted i add a new post document into the collection. Inside this document i have a map where users add confirmation to the event marking it as true and adding his own id.

Firestore Screen

var snap = await Firestore.instance
        .collection('user_posts')        
        .where("confirmations.${user.id}",isEqualTo: true)
        .getDocuments();

With this snippet i'm able to get all the posts confirmed by the user. The issue here is to get this a index is required to perform this query. And this index can't be generic. I can't create a index for each user.

Some idea of how to get it?

Thanks!!

diegoveloper · Accepted Answer · 2019-01-02 21:59:32Z

7

You'll want to turn the confirmations field into an array, and use the (relatively recent) array-contains and arrayUnion operations.

The equivalent query with an array like that would become:

var snap = await Firestore.instance
    .collection('user_posts')        
    .where("confirmations", arrayContains: user.id)
    .getDocuments();

And this way you only need an index on confirmations, which is added automatically.

For more on these see:

edited Jan 2, 2019 at 21:59

diegoveloper

104k25 gold badges253 silver badges201 bronze badges

answered Jan 2, 2019 at 20:20

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

Flutter Firestore where clause using map

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related