MongoDB update nested array of object by index [duplicate]

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
– ton1, Commented Nov 13, 2017 at 13:27

Arvind · Accepted Answer · 2017-11-13 13:29:10Z

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, 2017 at 13:29

Arvind

1,01610 silver badges16 bronze badges

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

1 Comment

ton1 Over a year ago

Thanks, it works,! I should have used some specific key for this. Thanks.

Collectives™ on Stack Overflow

MongoDB update nested array of object by index [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related