Push field to each element of object array (MongoDB)

Question

Let's say I have some documents of such type:

{ 
 _id: ObjectId("5abe0f5add80a30001eff68d"),
 obj_array: [ 
     { 
       a: 1,
       b: "some", 
       c: 134
     },
     { 
       a: 2, 
       b: "aaa",
       c: 564
     }
   ]
}

What I need to do is to update all the obj_array elements by pushing a new field d: "new_value". Expected result:

 { 
 _id: ObjectId("5abe0f5add80a30001eff68d"),
 obj_array: [ 
     { 
       a: 1,
       b: "some", 
       c: 134,
       d: "new_value"
     },
     { 
       a: 2, 
       b: "aaa",
       c: 564,
       d: "new_value"
     }
   ]
}

I didn't find any other solution but constructing new obj_array object and setting doc.obj_array with the new array. I wonder is there some more elegant way to do that? Here's my code:

myTable.find().forEach(function(document) {
    var new_array = [];
    document.obj_array.forEach(function(elem) {
        elem.d = "new_value";
        new_array.push(elem);
    })
    myTable.update({_id: document._id}, {$set: {obj_array: new_array}})
})

Ashh · Accepted Answer · 2018-08-08 10:16:33Z

5

You can use $[] the all positional operator which updates all the elements in an array

myTable.update(
  { "_id": document._id },
  { "$set": { "obj_array.$[].d": "new_value" }}
)

edited Aug 8, 2018 at 10:16

answered Aug 8, 2018 at 9:55

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Comments

Neel Rathod · Accepted Answer · 2018-08-08 10:05:28Z

1

You can simply achieve this by traverse array through $[] and update it:

for single update:

db.getCollection('test').update({},{ "$set": { "array.$[].key": "Value" }})

multiple updates:

db.getCollection('test').updateMany({},{ "$set": { "array.$[].key": "Value" }})

answered Aug 8, 2018 at 10:05

Neel Rathod

2,11115 silver badges29 bronze badges

Comments

Raj Jaril · Accepted Answer · 2018-08-08 10:09:08Z

1

1: run command npm install async --save

db.collection.find({_id:ObjectId("5abe0f5add80a30001eff68d")},function(err, result){
   if(result){
     async.eachSeries(result.obj_array,function(value, cb){
       value.d = "new_value";
       return cb();
     },function(){
       console.log(result)
     })
   }
})
//Once you get perfect result you can execute update query
db.collection.update({_id:ObjectId("5abe0f5add80a30001eff68d")},result)

NOTE: If you work with nodeJS then you need to install async, if you work with core javascript then you can change to common for-each loop.

its always work for me :)

edited Aug 8, 2018 at 10:09

answered Aug 8, 2018 at 10:02

Raj Jaril

3761 silver badge16 bronze badges

Collectives™ on Stack Overflow

Push field to each element of object array (MongoDB)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related