MongoDB : Add field in each array elements [duplicate]

Question

I'm starting with mongoDB and I want to update a nested array in my documents to add some initial value, but I can't find a way to do it with mong.

here is my document :

{
"_id":"cTZDL7WThChSvsvBT",
"name":"abc",
"players":[
  {
     "playerName":"Name1"
  },
  {
     "playerName":"Name2"
  }
 ]
}

What I want to do :

{
"_id":"cTZDL7WThChSvsvBT",
"name":"abc",
"players":[
  {
     "playerName":"Name1",
     "NewField1":0,
     "NewField2":0
  },
  {
     "playerName":"Name2",
     "NewField1":0,
     "NewField2":0
  }
 ]
}

Does anyone have a solution for this kind of situation?

glytching · Accepted Answer · 2017-07-24 16:32:23Z

3

This adds the new fields to the player array ...

db.collection.update({_id: 'cTZDL7WThChSvsvBT', players: {$exists: true}}, {$set: {'players.$.NewFieldOne': 0, 'players.$.NewFieldTwo': 0}})

... but since Mongo will only update the first element of an array which matches the query you are a bit stuffed. You can, of course, choose which array element to update by using the positional operator (as in my example) or by choosing a specific element (as the previous poster suggested) but until Mongo supports 'array updates' on all elements I think you're left with a solution such as: find the relevant documents and then update each one (i.e. a client side update solution).

answered Jul 24, 2017 at 16:32

glytching

48.5k11 gold badges127 silver badges129 bronze badges

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

1 Comment

Etienne Over a year ago

Thanks for your solution, works! And thanks also for the background explanation.

Etienne · Accepted Answer · 2017-07-24 16:57:32Z

2

I finally found a way by editing directly the document in JS like this :

  db.doc.find({_id: myDocId}).forEach(function (channel) {
    channel.players.forEach(function (player) {
        player.newField1 = 0;
        player.newField2 = 0;

    });
    db.doc.update({_id: myDocId}, channel);
  });

answered Jul 24, 2017 at 16:57

Etienne

311 silver badge3 bronze badges

Comments

icyber-ghost · Accepted Answer · 2017-07-24 16:06:04Z

1

considering you want to update an element which is an object also,

how about this?

db.collections.updateOne({_id: "cTZDL7WThChSvsvBT"}, {$set: {"players.0.NewField1": 0, "players.0.NewField2: 0}});

answered Jul 24, 2017 at 16:06

icyber-ghost

315 bronze badges

2 Comments

Etienne Over a year ago

Works well but only for the first "player". I don't know the size of the array and I need to add the values to each one.

icyber-ghost Over a year ago

i think thats similar to this case, stackoverflow.com/questions/4669178/…

Collectives™ on Stack Overflow

MongoDB : Add field in each array elements [duplicate]

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Related