How to update nested array object field value in MongoDB? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 months ago.

Improve this question

Update nested object values in array, we have multiple objects in array.

{ 
    "_id" : ObjectId("5a7e395e20a31e44e0e7e284"), 
    "name" : "a", 
    "address" : [
        {
            "street" : "123", 
            "town" : "bar"
        }, 
        {
            "street" : "Lower Street", 
            "town" : "bar"
        }, 
        {
            "street" : "123", 
            "town" : "foo"
        }
    ]
}

Need to update town is HNO if street is 123.

I have run this query but its updated all objects. db.coll.updateMany({"address.street": 123, {$set: { "town": "HNO"}}}) — muni
– muni, Commented Jan 10 at 11:47
This question is similar to: How do you update objects in a document's array (nested updating). If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — ray
– ray, Commented Jan 10 at 14:52

Yong Shun · Accepted Answer · 2025-01-10 12:25:11Z

1

Use positional filtered operator $[<identifier] to update the matching element in the array.

db.collection.updateMany({
  "address.street": "123"
},
{
  $set: {
    "address.$[a].town": "HNO"
  }
},
{
  arrayFilters: [
    {
      "a.street": "123"
    }
  ]
})

Demo @ Mongo Playground

edited Jan 10 at 12:25

answered Jan 10 at 11:56

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

How to update nested array object field value in MongoDB? [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related