Find and Update nested array element by ID

Question

I have a user model something like this

{
     _id:"something",
     email:"abc@gmail.com",
     contacts:[
     {_id:"123",status:"PENDING"},
     {_id:"456",status:"PENDING"},
     {_id:"789",status:"PENDING"}
     ]
}

And I have an id of one of the user's contacts "123" and I want to update that specific contact's status from "PENDING" to "SUCCESSFUL". How can I do that?

check this answer https://stackoverflow.com/questions/34431435/mongodb-update-an-object-in-nested-array — swapnil gautam, May 16 '22 at 06:20
This question already answered here: https://stackoverflow.com/questions/26156687/mongoose-find-update-subdocument — Alexander Paschenko, May 16 '22 at 06:22

score 2 · Accepted Answer · answered May 16 '22 at 06:21

Easiest way is with the array identifier $, like so:

db.collection.updateOne({
  email: "abc@gmail.com",
  "contacts._id": "123"
},
{
  "$set": {
    "contacts.$.status": "SUCCESSFUL"
  }
})

Mongo Playground

The array identifier updates the first element of the array that matches the query.

score 0 · Answer 2 · edited May 16 '22 at 07:35

0

db.collection.updateOne({ _id: "something" }, { contacts: [{ _id: "123", status: "SUCCESSFUL" }] }, function (err, res) {
    
})

edited May 16 '22 at 07:35

tripleee

175,061
34
275
318

answered May 16 '22 at 06:48

Harsh Gupta

548
1
4
10

Find and Update nested array element by ID

2 Answers2