Update nth array value under embedded documents in MongoDB

Question

I want to update only the nth position in that array, Instead of updating all the values in the array. db.patient.insertMany([ {firstName: "Thanga",lastName:"Durai", age:27,history:{disease:["Cold","ulergy"]}}]);

Here, Can you please tell me how to update value "Cold" into "Fever", remains are the same.

I already know another method to archive this, but using this I have to update all the values in an array: db.patient.updateOne({firstName:"Thanga","history.disease":"Cold"}, {$set:{lastName:"Yuvi","age":28,"history.disease":["Fever","Ulergy"]}} )

Can someone please tell me how to update only Cold into Fever?

Could you try db.patient.updateOne({firstName:"Thanga","history.disease":"Cold"}, {$set:{lastName:"Yuvi","age":28,"history.disease.$":"Fever"}}) ? — mickl
– mickl, Commented May 6, 2019 at 10:38

Dandi Kantesh · Accepted Answer · 2019-05-07 12:47:45Z

1

try this

db.patient.update(
  {
    "firstName":"Thanga",
    "history.disease":"Cold"
  }, 
  {
    $set:{
      "lastName":"Yuvi",
      "age":28,
      "history.disease.0":"Fever"
   }
  })

edited May 7, 2019 at 12:47

answered May 6, 2019 at 12:52

Dandi Kantesh

293 bronze badges

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

Collectives™ on Stack Overflow

Update nth array value under embedded documents in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related