Find and Update nested array element by ID

Question

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?

This question already answered here: stackoverflow.com/questions/26156687/… — Alexander Paschenko
– Alexander Paschenko, Commented May 16, 2022 at 6:22

Tom Slabbaert · Accepted Answer · 2022-05-16 06:21:02Z

2

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.

answered May 16, 2022 at 6:21

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

Comments

tripleee · Accepted Answer · 2022-05-16 07:35:13Z

0

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

edited May 16, 2022 at 7:35

tripleee

192k37 gold badges317 silver badges366 bronze badges

answered May 16, 2022 at 6:48

Harsh Gupta

7181 gold badge6 silver badges11 bronze badges

Collectives™ on Stack Overflow

Find and Update nested array element by ID

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related