How to increment a map value in a Firestore array

Question

I have a firestore firebase database , in which I have a collection users there is an array in the collection and in the array there is a map in map there is a field qty.. I want to increment that qty value..

using increment doesnt help as the qty is inside a array index

    db.collection("users").doc(checkId).update({
                myCart: firebase.firestore.FieldValue.arrayUnion({
                    qty: firebase.firestore.FieldValue.increment(1),

                }),

this is the error Output => Uncaught (in promise) FirebaseError: Function FieldValue.arrayUnion() called with invalid data. FieldValue.increment() can only be used with update() and set()

score 6 · Accepted Answer · answered Oct 09 '19 at 18:49

6

The field you want to update is embedded in an array. In this case, you can't use FieldValue.increment(), since it's not possible to call out an array element as a named field value.

What you'll have to do instead is read the entire document, modify the field in memory to contain what you want, and update the field back into the document. Also consider using a transaction for this if you need to update to be atomic.

(If the field wasn't part of an array, you could use FieldValue.incrememnt().)

answered Oct 09 '19 at 18:49

Doug Stevenson

268,359
30
341
380

Ok Understood Thank uh – Mehtab Singh Edhan Oct 09 '19 at 18:53
Use dot notation like the answer given by Coder Marine below suggests. Way easier – Marvioso Oct 14 '20 at 19:41

Frank van Puffelen · Answer 2 · 2021-11-26T15:27:02.127

5

My answer below won't work, given that the qty is in an array. The only way to update an item in an array is to read the entire document, update the item in the array, and then write the entire array with the updated item back to the document.

An alternative would be to use a map instead of an array, and then update the qty using the approach outlined in my (old, and non-working) answer below

You need to specify the full path to the field you're trying to update. So I think in your case, that'll be:

db.collection("users").doc(checkId).update({
  "myCart.0.qty": firebase.firestore.FieldValue.increment(1)
}),

edited Nov 26 '21 at 15:27

answered Oct 09 '19 at 17:07

Frank van Puffelen

499,950
69
739
734

3

Sir this is overwriting all the values in " myCart.0 " with qty:1 , I just want to increment that qty only – Mehtab Singh Edhan Oct 09 '19 at 18:10

Coder Marine · Answer 3 · 2020-04-29T18:28:58.110

2

As of today (29-04-2020)... this is tested by me.

Suppose my data structure is like this:

collection: Users Any document: say jdfhjksdhfw It has a map like below map name: UserPageVisits map fields: field1,field2,field3 etc

Now we can increment the number field in the map like below:

mapname.field1 etc...

That is use the dot operator to access the fields inside the map just like you would do to an object of javascript.

JAVA Code (Android), update the field using transactions so they can complete atomically.

transaction.update(<documentreference object>,"UserPageVisits.field1",FieldValue.increment(1));

I have just pushed a version of my app which uses this concept and it's working.

Kudos !!

My Best Regards

edited Apr 29 '20 at 18:28

answered Apr 29 '20 at 17:31

Coder Marine

53
10

Thanks! This worked with the Flutter SDK and means I don't have to read the value first, increment and then write. I can just increment directly. Saved me a bunch of reconfiguration work, this should be the accepted answer! – Marvioso Oct 14 '20 at 19:40
Glad it helped you. :-) – Coder Marine Jan 05 '21 at 07:25

score -1 · Answer 4 · answered Aug 30 '21 at 23:48

-1

Previous answers helped me as well, but dont forget about the "merge" property!!! Otherwise it will overwrite your entire array, losing other fields.

var myIndex = 0;
const userRef = db.collection('users').doc(checkId);
return userRef.update({
      'myCart.${myIndex}.qty': admin.firestore.FieldValue.increment(1)
    }, {
        merge: true
    });

answered Aug 30 '21 at 23:48

Alex Balas

69
1
1

The `.update()` method has no `{ merge: true }` option. I believe you are thinking about `.set(data, { merge: true})` – Frenchcooc Oct 04 '21 at 21:24

How to increment a map value in a Firestore array

4 Answers4

Linked