MongoDB Increment Array of objects

Question

Can someone help me how to properly make a update increment query for my data

For example I would like to increment the quantity of Unix Mug by 1, by the user with email: "[email protected]"

This one doesn't work for me

UserData.updateOne({email: email}, { $inc : {items: [{quantity: 1}]}})

Please share the data as snippet instead of image. Thanks. — Yong Shun
– Yong Shun, Commented Sep 4, 2022 at 4:51

Dharmaraj · Accepted Answer · 2022-09-04 05:01:51Z

1

You can use the positional operator ($) as shown below:

db.users.updateOne({
  email: "USER_EMAIL",
  "items.productName": "Unix Mug"
}, {
  $inc: {
    "items.$.quantity": 1
  }
})

answered Sep 4, 2022 at 5:01

Dharmaraj

51.3k8 gold badges67 silver badges100 bronze badges

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

1 Answer 1