update query not working in mongoDB object

Question

I am having below format document

{
   "_id":"5f10481e74d83d4b726fdf33",
   "name":"1234",
   "settings":{
      "allowedUser":true,
      "theme":"lowergrade"
   }
}

I want to write update query for settings.theme, so I have written below mongo query

db.test.update({
  _id: "5f10481e74d83d4b726fdf33"
},
{
  $set: {
    "settings": {
      "theme": "lowergrade123",
      
    }
  }
})

Update is happening proper but "allowedUser" : true, key and value was deleted.

This is my expected answer

{
   "_id":"5f10481e74d83d4b726fdf33",
   "name":"1234",
   "settings":{
      "allowedUser":true,
      "theme":"lowergrade123"
   }
}

turivishal · Accepted Answer · 2020-11-20 07:54:37Z

1

db.test.update({ _id: "5f10481e74d83d4b726fdf33" }, {
  $set: {
    "settings.theme":  "lowergrade123",
  }
})

You need to use . to set a value of a field. You are actually replacing settings.

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

answered Nov 20, 2020 at 7:15

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

1 Answer 1