mongodb insert a new field into an array

Question

I am trying to insert a new field to an array of objects

{
    "_id": "543356fe0c9af6066e68970c",
    "createdDate": "2014-10-06 07:59 pm",
    "cancle": false,
    "eventDate": "2014/12/12",
    "eventstatus": true,
    "location": "chennai",
    "userId": "54310801e2659ecc3650100b",
    "createdBy": "one",
    "eventName": "tea ",
    "__v": 0,
    "friends": [
        {
            "userId": "54310814e2659ecc3650100c",
            "userName": "two",
            "phoneNumber": "22222222"
        },
        {
            "userId": "54310945e2659ecc3650100d",
            "userName": "three",
            "phoneNumber": "33333333"
        },
        {
            "userId": "54334def7e85de48638d1069",
            "userName": "four",
            "phoneNumber": "44444444"
        }
    ]
}

I want to add "status" : 0 to all the objects inside friends array

I tried using addtoset, push and multiple ways, its adding as a new object in friends array.

db.events.update({},{$push:{ "friends" : {"status" : 0} }},false,true)
db.events.update({},{$addToSet : {'friends' : $each: [{ 'status':0}]}},false,true)

Please let me know what i am doing wrong. Thanks for your help

Josh Lee · Accepted Answer · 2018-12-10 20:57:08Z

15

You can use this to update the arrays

db.events.find().forEach(function(e){
  var t=e.friends;
  t.forEach(function(e){
    e.status=0
  });
  db.events.update({_id:e._id},{$set:{friends:t}})
})

Run this in your mongo terminal.

edited Dec 10, 2018 at 20:57

Josh Lee

179k39 gold badges278 silver badges282 bronze badges

answered Oct 13, 2014 at 9:32

mallik

5675 silver badges13 bronze badges

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

1 Comment

rick Over a year ago

Instead of update use updateMany now.

Disposer · Accepted Answer · 2014-10-13 09:32:53Z

1

Don't know about problem with the code but I have the right code for it

var cursor = db.events.find();
cursor.forEach(function(item)
{
    var friends = item.friends;
    friends.forEach(function(elem) 
    {
        elem['status'] = '....',
    })    
    db.events.update({_id: item._id}, item);    
});

It is working with mongo shell, but I don't know about javascript

edited Oct 13, 2014 at 9:32

answered Oct 13, 2014 at 9:21

Disposer

6,3915 gold badges34 silver badges39 bronze badges

Comments

Jens · Accepted Answer · 2018-03-13 15:50:23Z

0

In Java and Springs MongoTemplate you can add a new field to all entries in a array with:

final Query query = new Query(Criteria.where("states.$[].date").exists(false));    
final Update update = new Update().set("states.$[].stateSetBy", "SYSTEM");
mongoTemplate.updateMulti(query, update, "<collection_name>");

in this example you have a document with an array of "states" and want to add a new field to every entry of this array.

most important part is the $[] to address every entry in the array

see: https://docs.mongodb.com/manual/reference/operator/update-array/

answered Mar 13, 2018 at 15:50

Jens

11 bronze badge

Comments

Gabriel Mochi · Accepted Answer · 2023-01-24 19:17:56Z

0

This answer can also help you: https://stackoverflow.com/a/67162997/7724011

It uses the updateMany method with aggregation pipeline to iterate over the array items and then use $mergeObjects to add new properties to each one of them.

answered Jan 24, 2023 at 19:17

Gabriel Mochi

6791 gold badge6 silver badges11 bronze badges

Comments

Ali · Accepted Answer · 2014-10-13 08:43:48Z

-1

need to add multi true and call function require when up

db.events.update({},{$push:{ "friends" : {"status" : 0} }},{ multi: true },function(e,update){});

answered Oct 13, 2014 at 8:43

Ali

73 bronze badges

Collectives™ on Stack Overflow

mongodb insert a new field into an array

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related