How to replace the value in nested arrays in multiple mongodb docs at once

Question

Here i wanted to replace the value of country to something else wherever it presents like "India". I have multiple docs with same structure and would like update all at once. It should not affect other keys and just wanted to update the country.

Tried with Set operator and not getting it correctly.

{
    "_id" : "1",
    "teams" : 
    [ 
        {
            "type" : "local",
            "isEnabled" : "true",
            "Country":"India"
            "names" : 
            [ 
                { "name": "kumar","Nationality":"indian","BirthPlace":"Goa","Age":"U25" },
                { "name": "kannan","Nationality":"indian","BirthPlace":"Kerala","Age":"U25"}
            ]
        },
        {
            "type" : "national",
            "isEnabled" : "true",
            "Country":"India"
            "names" : 
            [ 
                { "name": "kumar","Nationality":"indian","BirthPlace":"Goa","Age":"U25" },
                { "name": "kannan","Nationality":"indian","BirthPlace":"Kerala","Age":"U25"}
            ]
        },
        {
            "type" : "international",
            "isEnabled" : "true",
            "Country":"England"
            "names" : 
            [ 
                { "name": "kumar","Nationality":"indian","BirthPlace":"Goa","Age":"U25" },
                { "name": "kannan","Nationality":"indian","BirthPlace":"Kerala","Age":"U25"}
            ]
        },
        {
            "type" : "national",
            "isEnabled" : "true",
            "Country":"India"
            "names" : 
            [ 
                { "name": "kumar","Nationality":"indian","BirthPlace":"Goa","Age":"U25" },
                { "name": "kannan","Nationality":"indian","BirthPlace":"Kerala","Age":"U25"}
            ]
        },
        {
            "type" : "international",
            "isEnabled" : "true",
            "Country":"Newzealand"
            "names" : 
            [ 
                { "name": "kumar","Nationality":"indian","BirthPlace":"Goa","Age":"U25" },
                { "name": "kannan","Nationality":"indian","BirthPlace":"Kerala","Age":"U25"}
            ]
        }
    ]
}

Wernfried Domscheit · Accepted Answer · 2021-03-23 07:57:18Z

1

Try this one:

db.collection.updateMany(
   {},
   { $set: { "teams.$[element].Country": "Republic of India" } },
   { arrayFilters: [{ "element.Country": "India" }] }
);

answered Mar 23, 2021 at 7:57

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

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

1 Comment

Tamilselvan Over a year ago

Sorry was away due to sick. This helps. Thanks a lot

abrorkhamidov · Accepted Answer · 2021-03-31 07:09:36Z

1

Try this one:

db.collection.updateMany({},
 {
   $set: {
    "teams.$[].Country": "India"
   }
})

answered Mar 31, 2021 at 7:09

abrorkhamidov

1436 bronze badges

Collectives™ on Stack Overflow

How to replace the value in nested arrays in multiple mongodb docs at once

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related