MongoDB update nested array of object by index

Question

Let's suppose to there is db like below...

{ _id: 1234,
  key: 'Contacts',
  value: [
     { name: 'McDonald', phone: '1111'}, 
     { name: 'KFC', phone: '2222'}
  ]
}

And I want to change KFC's phone number to '3333'.

What I did is

DB.findOne({ key: 'Contacts' }, function(err, db){

        db.value[1]['phone'] = '3333'
        db.save(function(err, result){ 
            // done 
        })
    }
)

But it didn't update the database. What am I wrong?

There's no specific _id in elements of array for some reason.
Only the way to find specific element is index.

@JohnKennedy How can I access to nested object from `findOneAndUpdate`? I don't know how to... — ton1, Nov 13 '17 at 13:27

score 2 · Accepted Answer · answered Nov 13 '17 at 13:29

2

Use the positional operator $

more info : https://docs.mongodb.com/manual/reference/operator/update/positional/#up.S

DB.update({key: "Contacts", "value.name": "KFC" },
         { $set: { "value.$.phone" : 666 } },function(err,doc){

         });

answered Nov 13 '17 at 13:29

Arvind

1,006
10
16

Thanks, it works,! I should have used some specific key for this. Thanks. – ton1 Nov 13 '17 at 13:44

MongoDB update nested array of object by index

1 Answers1