Updating a nested array object in Mongo db

Question

This is the json object

{
"account_id":"1",
"sections":[ {
    "section_name":"abc",
    "labels": [{
        "name": "label1",
        "value": "value1"
        },
        {
        "name": "label2",
        "value": "value2"
        }]
    },
     {
    "section_name":"def",
    "labels": [{
        "name": "label3",
        "value": "value3"
        }]
    }]
}

In this json object I wanted to change the value of label3 from value3 to value4 in the section def. There are different accounts but I have listed only one json object here.

I have used the below code, but it didn't work for me. Here I have passed section name(section), label name (label) and label value (value).

let query = {
account_id: event.accountId.toString(),
sections: {
    section_name: section,
    labels: {
    label_name: label
       }
     }
   };

   return using(connectDatabase(), db => {
   return db.collection(TABLE_NAME).updateOne(query, { $set: { 
  'sections.$.labels.$.value': value } });
  }).then(
    result => {
      cb(null, responseObj(result, 200));
    },
    err => {
      cb(responseObj(err, 500));
    }
  );

Can someone help me ? Thanks in advance

any errors while running that query?

Naga Sai A
– Naga Sai A

2019-03-11 03:47:40 +00:00
Commented Mar 11, 2019 at 3:47 — Naga Sai A
– Naga Sai A, Commented Mar 11, 2019 at 3:47
Its not updating in the database.

Uthpala Pitawela
– Uthpala Pitawela

2019-03-11 03:48:38 +00:00
Commented Mar 11, 2019 at 3:48 — Uthpala Pitawela
– Uthpala Pitawela, Commented Mar 11, 2019 at 3:48
posted answer using arrayFilters, hope it works for you

Naga Sai A
– Naga Sai A

2019-03-11 05:13:43 +00:00
Commented Mar 11, 2019 at 5:13 — Naga Sai A
– Naga Sai A, Commented Mar 11, 2019 at 5:13

juco · Accepted Answer · 2019-09-13 08:58:19Z

1

To achieve expected result, use below option of using arrayFilters for nested objects

Get main Object using account_id
Using ArrayFiter $[identfier].section : "def" and $[identfier].name: "label3"

 db.collection(TABLE_NAME).updateOne({
    account_id: event.accountId.toString(),
    {
      "$set": {
        "sections.$[elem].labels.$[label].value": value
      }
    },
    {
      "arrayFilters": [{
        "elem.section_name": section
      }, {
      "label.name": label
      }]
    }
})

Please refer this link for more details - https://docs.mongodb.com/manual/reference/operator/update/positional-filtered/

Another example of arrayFilters with example - How to Update Multiple Array Elements in mongodb

edited Sep 13, 2019 at 8:58

juco

6,3423 gold badges27 silver badges42 bronze badges

answered Mar 11, 2019 at 4:57

Naga Sai A

11k1 gold badge24 silver badges41 bronze badges

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

8 Comments

Uthpala Pitawela Over a year ago

"Unsupported projection option: $set: { sections.$[elem].labels.$[label].value: \"valllll\" }", <----- got this error

Uthpala Pitawela Over a year ago

I have checked this in RoboMongo . Will that affect for this error?

Naga Sai A Over a year ago

@UthpalaPitawela, should enclose this quotes - sections.$[elem].labels.$[label].value

Uthpala Pitawela Over a year ago

I think the probelm is the MOngo version where this works only for versions higher 3.6 while my mongo version is less than 3.6

Naga Sai A Over a year ago

oh k @UthpalaPitawela :) , Did you try to upgrade to 3.6 or are you trying for solution for version less than 3.6?

|

Swati · Accepted Answer · 2019-03-11 08:28:30Z

0

Updated Query You can use this query

db.testcol.update(
   { },
   { $set: { "sections.$[element].labels.$[element1].value" : "value1New" } },
   { multi: true,
     arrayFilters: [ { "element.section_name": { $eq: "abc" } },  { "element1.name": { $eq: "label1" } }]
   }
)

You can check the following query: Where 1 is the index value of the array.

db.testcol.update(
    {
        account_id:"1", 
        "sections.section_name":"def"
    }, 
    {
        $set:{
            "sections.1.labels.1.value":"value8"
        }
    }
)

If you want to update all the values then you can use:

db.testcol.update(
{
    account_id:"1", 
    "sections.section_name":"def"
}, 
{
    $set:{
        "sections.$[].labels.$[].value":"value8"
    }
}

)

Please check and let me know if it is help-full.

edited Mar 11, 2019 at 8:28

answered Mar 11, 2019 at 5:02

Swati

1031 silver badge14 bronze badges

1 Comment

Uthpala Pitawela Over a year ago

This does not work as sections.1.labels.1.value":"value8 , updates index 1 and sometimes the intended label not always in the index 0.

Collectives™ on Stack Overflow

Updating a nested array object in Mongo db

2 Answers 2

8 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related