MongoDb - How can I update multiple elements of a nested object using $set?

Question

Lets say I have the following document:

{name: 'myDoc', nestedDoc: {a: 1, b: 2, c: 3}}

And I would like to merge with the nestedDoc a new object:

{b: 20, c:30, d:40}

So the resulting object would be:

{name: 'myDoc', nestedDoc: {a: 1, b: 20, c: 30, d: 40}}

How can I go about doing this in a single query? I feel like I need multiple $set calls however object property names must be unique. In other words, I wish I could do the following:

db.myCollection.update({name: 'myDoc', nestedDoc: {$set: {b: 20}, $set: {c: 30}, $set: {d: 40}});

Some extra details are that the MongoDB version is 1.8.2 and I am using the NodeJS node-native driver.

Manuel Jordan · Accepted Answer · 2021-04-29 20:31:19Z

35

You can update by using the following:

db.myCollection.update({
    name: 'mydoc'
}, {
    $set: {
        'nestedDoc.b': 20,
        'nestedDoc.c': 30,
        'nestedDoc.d': 40
    }
})

Here is more information about update command:

Update Documents

edited Apr 29, 2021 at 20:31

Manuel Jordan

16.5k26 gold badges113 silver badges187 bronze badges

answered Oct 1, 2011 at 3:52

Dmitry

4965 silver badges5 bronze badges

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

Comments

Robin Jiao · Accepted Answer · 2019-10-10 07:43:35Z

-2

update: this answer is not a correct update!

this works too in my app, and easy to read

db.myCollection.update({
    name: 'mydoc'
   }, 
   {
    $set: {
        nestedDoc:{
           b: 20,
           c: 30,
           d: 40,
       } 
    }
})

edited Oct 10, 2019 at 7:43

answered Jun 21, 2019 at 6:55

Robin Jiao

11310 bronze badges

1 Comment

Viktor Hedefalk Over a year ago

This will replace nestedDoc with the contents, not update its fields.

Collectives™ on Stack Overflow

MongoDb - How can I update multiple elements of a nested object using $set?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related