Update nested array field for multiple docs at once

Question

I have a huge number of records in the collection on the below structure.

Here I want to update all floor fields as an empty string "", wherever it's "n/a". It should not affect other blocks which already have value for the floor like the First, Second Floor.

Can someone help on this?

{
    "id" : "181",
    "EID" : "83",
    "History" : [ 
        {
            "aNum" : "12324",
            "dev" : [ 
                {
                    "type" : "",
                    "room" : "Office",
                    "floor" : "Second Floor"
                }, 
                {
                    "type" : "",
                    "room" : "Bedroom",
                    "floor" : "n/a"
                },
                {
                    "type" : "",
                    "room" : "Bedroom",
                    "floor" : "First Floor"
                },
                {
                    "type" : "",
                    "room" : "Bedroom",
                    "floor" : "n/a"
                },
            ]
        }
    ]
}

Yong Shun · Accepted Answer · 2021-11-24 14:30:52Z

2

With arrayFilters and filtered $[<identifier>] operator.

db.collection.update({},
{
  $set: {
    "History.$[].dev.$[dev].floor": ""
  }
},
{
  arrayFilters: [
    {
      "dev.floor": "n/a"
    }
  ],
  multi: true
})

Sample Mongo Playground

answered Nov 24, 2021 at 14:30

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

Update nested array field for multiple docs at once

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related