Update nested array objects based on a property in MongoDB

Question

I have a MongoDB collection which has documents which look like this:

{
    createdTimestamp: 111111111111,
    items: [{
        itemName: 'Name 1',
        quantity: 10
    }, {
        itemName: 'Name 2'
        quantity: 20
    }]
}

Now, I want to update all documents so that itemName: 'Name 1' would be updated to itemName: 'New Name'. After an update, the above document should look like as below:

{
    createdTimestamp: 111111111111,
    items: [{
        itemName: 'New Name',
        quantity: 10
    }, {
        itemName: 'Name 2'
        quantity: 20
    }]
}

Is there any way to do this, without iterating over all documents myself?

Ashh · Accepted Answer · 2018-07-31 04:50:37Z

7

You need to use $ positional operator to update an array element and with multi: true option you can update multiple document with the same match

db.collection.update(
  { 'items': { '$elemMatch': { 'itemName': 'Name 1' }}},
  { '$set': { 'items.$.itemName': 'New Name' }},
  { 'multi': true }
)

and with the mongodb 3.6 arrayFilters

db.collection.update(
  { 'items': { '$elemMatch': { 'itemName': 'Name 1' }}},
  { '$set': { 'items.$[item].itemName': 'New Name' }},
  { 'arrayFilter': [{ 'item.itemName': 'Name 1' }], 'multi': true }
)

edited Jul 31, 2018 at 4:50

answered Jul 31, 2018 at 4:27

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

Lahiru Chandima Over a year ago

It worked. Had to do a small change: '$elemMatch': {itemName: 'Name 1'}

turivishal · Accepted Answer · 2021-05-13 19:15:48Z

1

you can use mongoDb arrayFilters

db.collection.update(
  { },
  { "$set": { "items.$[elem].itemName": 'new Name' } },
  { "arrayFilters": [{ "elem.itemName": 'Name 1' }], "multi": true }
)

edited May 13, 2021 at 19:15

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

answered Jul 31, 2018 at 4:34

Amit Wagner

3,1843 gold badges23 silver badges39 bronze badges

Collectives™ on Stack Overflow

Update nested array objects based on a property in MongoDB

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related