Update value of key in Object in nested array of objects in MongoDB

Question

I am trying to update data of "array1.array2._id": ObjectId("627a6fab60dc3c523b396af1") and Set Name to John But it's updating in all array2's first element's name to John.

db.getCollection('tests')
.updateOne({ "array1.array2._id": ObjectId("627a6fab60dc3c523b396af1") },{ $set: { "array1.$[].array2.$.name" : "John" } })

{
    "_id" : ObjectId("627a6fab60dc3c523b396aec"),
    "array1" : [ 
        {
            "array2" : [ 
                {
                    "_id" : ObjectId("627a6fab60dc3c523b396af1"),
                    "name" : "test"
                }, 
                {
                    "_id" : ObjectId("627a6fab60dc3c523b396af2"),
                    "name" : "ABC"
                }
            ],
            "_id" : ObjectId("627a6fab60dc3c523b396aed")
        }, 
        {
            "array2" : [ 
                {
                    "_id" : ObjectId("627a6fab60dc3c523b396af3"),
                    "name" : "XYZ"
                }, 
                {
                    "_id" : ObjectId("627a6fab60dc3c523b396af4"),
                    "name" : "Testing"
                }
            ],
            "_id" : ObjectId("627a6fab60dc3c523b396aee")
        }
    ]
}

Does this answer your question? How to update the value to the nested object array in mongodb document? — nimrod serok
– nimrod serok, Commented May 11, 2022 at 14:13
@nimrodserok No. In that answer they have "code": "Maroon" to check But we don't have _id : ObjectId("627a6fab60dc3c523b396aed"). We have only one _id ObjectId("627a6fab60dc3c523b396af1"). — Sahil Thummar
– Sahil Thummar, Commented May 11, 2022 at 14:20

nimrod serok · Accepted Answer · 2022-05-11 14:25:39Z

2

Based on this great answer by @R2D2, you can do:

db.collection.update({
  "array1.array2._id": ObjectId("627a6fab60dc3c523b396af1")
},
{
  $set: {
    "array1.$[].array2.$[y].name": "John"
  }
},
{
  arrayFilters: [
    {
      "y._id": ObjectId("627a6fab60dc3c523b396af1")
    }
  ]
})

As you can see on this playground example

answered May 11, 2022 at 14:25

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Update value of key in Object in nested array of objects in MongoDB

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related