mongoDB: Update nested array object

Question

I would like the nested object with the id BAHx9KeKjuMePce6f to be updated:

{
    "_id" : "sgG6G9XTvvjj7uxwQ",
    "target" : [
        {
            "title" : "content",
            "id" : "ePce6fBAHx9KeKjuM"
        },
        {
            "title" : "content",
            "id" : "BAHx9KeKjuMePce6f" <--
        }
    ]
}

So this is what I tried:

var newData = { title: "new", one: "more", id: 'BAHx9KeKjuMePce6f' };

Collection.update(
    { _id: 'sgG6G9XTvvjj7uxwQ', 'target.id': 'BAHx9KeKjuMePce6f' }, 
    { $set: newData }
);

The result should be:

{
    "_id" : "sgG6G9XTvvjj7uxwQ",
    "target" : [
        {
            "title" : "content",
            "id" : "ePce6fBAHx9KeKjuM"
        },
        {
            "title": "new", 
            "one": "more",
            "id" : "BAHx9KeKjuMePce6f"
        }
    ]
}

Volodymyr Synytskyi · Accepted Answer · 2016-01-25 10:35:17Z

2

In order to update specific element in array you can use mongodb positional $ operator.

Try the following query:

var newData = { title: "new", one: "more", id: 'BAHx9KeKjuMePce6f' };

Collection.update(
    { _id: 'sgG6G9XTvvjj7uxwQ', 'target.id': 'BAHx9KeKjuMePce6f' }, 
    { $set: { 'target.$': newData } }
);

answered Jan 25, 2016 at 10:35

Volodymyr Synytskyi

4,0751 gold badge17 silver badges19 bronze badges

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

Comments

Alex · Accepted Answer · 2016-01-25 10:54:01Z

1

You need the use the positional parameter $ to indicate you want to update the array element, rather than the root of the document, see the documentation:

Collection.update({
  _id: 'sgG6G9XTvvjj7uxwQ',
  'target.id': 'BAHx9KeKjuMePce6f'
}, {
  $set: {
    "target.$": newData
  }
});

edited Jan 25, 2016 at 10:54

answered Jan 25, 2016 at 10:40

Alex

21.8k11 gold badges68 silver badges77 bronze badges

Collectives™ on Stack Overflow

mongoDB: Update nested array object

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related