update object in multiple Arrays

Question

here the following my document

{
  langid: "java101",
 language : { 
         frontEnd: [{
                     stuid  : "st1",
                     stuName : "Siva",
                     course : "java"
                    },
                    {
                     stuid  : "st1",
                     stuName : "Siva",
                     course : "DotNet"
                    },
                    {
                     stuid  : "st2",
                     stuName : "ramu",
                     course : "java"
                    }
                   ],
        backend : [{
                     stuid  : "st1",
                     stuName : "Siva",
                     course : "mongo"
                    },
                    {
                     stuid  : "st1",
                     stuName : "Siva",
                     course : "oracle"
                    },
                    {
                     stuid  : "st2",
                     stuName : "ramu",
                     course : "mongo"
                    }]
          }
}

I need chage stuName Siva to SivaRamaKrishna

You should try this https://stackoverflow.com/questions/23577123/updating-a-nested-array-with-mongodb — Mayur Vaghasiya, Mar 17 '21 at 06:21

score 0 · Accepted Answer · edited Mar 17 '21 at 08:14

0

You could try something like this

db.collection.update({
  "$and": [
    {
      "language.frontEnd.stuName": "Siva"
    },
    {
      "language.backend.stuName": "Siva"
    }
  ]
},
{
  "$set": {
    "language.frontEnd.$.stuName": "SivaRamaKrishna",
    "language.backend.$.stuName": "SivaRamaKrishna"
  }
})

It working only one fields

See working

edited Mar 17 '21 at 08:14

Anji

55
7

answered Mar 17 '21 at 06:33

Shubham Dixit

9,242
4
27
46

update object in multiple Arrays

1 Answers1