MongoDB - How to add a field to all object within an array

Question

I have a document with a field called info, and info has a field inside it called data. data is an array of objects. I want to add a new boolean field, isActive: false, to each object in data, with updateMany.

This is how it looks now

{ 
    info: {
        data: [{
                "name": "Max"
            },
            {
                "name": "Brian"
            },
            ...
        ]
    }
}

This is what I want:

{ 
    info: {
        data: [{
                "name": "Max",
                "isActive": false
            },
            {
                "name": "Brian",
                "isActive": false
            },
            ...
        ]
    }
}

How do I do that?

This query is for querying or updating documents?

Yong Shun
– Yong Shun

2022-07-25 12:19:48 +00:00
Commented Jul 25, 2022 at 12:19 — Yong Shun
– Yong Shun, Commented Jul 25, 2022 at 12:19
@YongShun updating

TheStranger
– TheStranger

2022-07-25 12:20:32 +00:00
Commented Jul 25, 2022 at 12:20 — TheStranger
– TheStranger, Commented Jul 25, 2022 at 12:20

Yong Shun · Accepted Answer · 2022-07-25 12:23:32Z

10

Add the isActive field with all positional operator $[].

db.collection.update({},
{
  $set: {
    "info.data.$[].isActive": false
  }
},
{
   multi: true
})

Consider applying { multi: true } if you want to update multiple documents.

answered Jul 25, 2022 at 12:23

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

3 Comments

TheStranger Over a year ago

instead of multi: true is it possible to use updateMany? Because I'm already doing other things using updateMany, so I could just put the query within that script?

Yong Shun Over a year ago

If I not mistaken, .updateMany() is for Mongoose. The { multi: true } is equivalent to .updateMany() in Mongoose. Because I'm already doing other things using updateMany, so I could just put the query within that script?, it depends on what is the data and query that you used currently.

Rob Over a year ago

update is now giving a deprecation warning so it seems that the updateMany answer will be more appropriate in the future

Mark · Accepted Answer · 2023-05-12 09:36:40Z

2

UpdateMany is also possible, for example in Compass.

db.collection.updateMany({"info.data.isActive":{$exists:false}},{$set:"info.data.$[].isActive":false}})

answered May 12, 2023 at 9:36

Mark

212 bronze badges

Collectives™ on Stack Overflow

MongoDB - How to add a field to all object within an array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related