PyMongo - Update the field for the object in nested array

Question

Trying to update the nested object for the document in MongoDB.

{
    "items" : [
      {
        "id": 1,
        "name": "a",
        "child": [
          { "id": 11, "name": "aa" },
          { "id": 12, "name": "bb" },
         ]
      },
    ]
}

Need to update the child id to 13 whose name is "aa".

O/P, which I am trying to get

{
    "items" : [
      {
        "id": 1,
        "name": "a",
        "child": [
          { "id": 13, "name": "aa" },
          { "id": 12, "name": "bb" },
        ]
      },
    ]
}

Yong Shun · Accepted Answer · 2022-07-28 07:37:24Z

1

Work with $[<identifier>] filtered positional operator and arrayFilters.

db.collection.update({
  "items.child.name": "aa"
},
{
  $set: {
    "items.$[].child.$[c].id": 13
  }
},
{
  arrayFilters: [
    {
      "c.name": "aa"
    }
  ]
})

Sample Mongo Playground

answered Jul 28, 2022 at 7:37

Yong Shun

54.3k6 gold badges37 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

PyMongo - Update the field for the object in nested array

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related