Question 117977 in Mongodb Question posted in
The official documentation can be found here.

Mongodb – Find and Update nested array element by ID

I have a user model something like this

{
     _id:"something",
     email:"[email protected]",
     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?

Tags:

2

Answers


  1. 0

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

    db.collection.updateOne({
  email: "[email protected]",
  "contacts._id": "123"
},
{
  "$set": {
    "contacts.$.status": "SUCCESSFUL"
  }
})

    Mongo Playground

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

    Login or Signup to reply.
  2. 0 
    db.collection.updateOne({ _id: "something" }, { contacts: [{ _id: "123", status: "SUCCESSFUL" }] }, function (err, res) {
    
})
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search