Update deeply nested array element in mongodb

Question

I want to update an inner element state field in a mongodb collection, I have given below the collection and my mongodb update statement.

    {
        "_id" : ObjectId("561b4c83e3603fcd1badaeb3"),
        "continent" : "Asia",
        "countries" : [
            {
                "country" : "India",
                "_id" : ObjectId("561b83c3626fca4a23c0131f"),
                "states" : [
                    {
                        "state" : "Kerala"
                    }
                 ........ many other states
                ]
            }
        ],
        "__v" : 0
    }

I used this mongodb query.

    db.places.update({ "_id" : ObjectId("561b4c83e3603fcd1badaeb3"), "countries.states.state": "Kerala" },{ $set: { "country.$.states.$.state": "Tamilnad" } } );

Expected result

    {
        "_id" : ObjectId("561b4c83e3603fcd1badaeb3"),
        "continent" : "Asia",
        "countries" : [
            {
                "country" : "India",
                "_id" : ObjectId("561b83c3626fca4a23c0131f"),
                "states" : [
                    {
                        "state" : "Goa"
                    }
                 ........ many other states
                ]
            }
        ],
        "__v" : 0
    }

Please help me.

Possible duplicate of MongoDB Update Deep Array

chridam
– chridam

2015-10-12 11:21:53 +00:00
Commented Oct 12, 2015 at 11:21 — chridam
– chridam, Commented Oct 12, 2015 at 11:21

Rohit Jain · Accepted Answer · 2015-10-12 15:55:47Z

0

You can try to use $addToSet to add an element in array

db.collection.update({ "_id" : ObjectId("561b4c83e3603fcd1badaeb3"), "countries.states.state": "Kerala" },{ $addToSet: { "countries.$.states": {"state":"Goa"} } } )

Hope it will help

answered Oct 12, 2015 at 15:55

Rohit Jain

2,11219 silver badges19 bronze badges

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

Comments

Ani Sargsyan · Accepted Answer · 2017-08-18 07:05:49Z

Mongo doesn't support multiple positional operators. You'll have to do it with js using mongo's foreach method

db.coll.find().forEach(function( doc ) {
  //supposing only one country will match the query 
    var statesCount = doc.countries[0].states.length;
    for(var i=0; i<statesCount; i++){
        if(doc.countries[0].states[i].state == "Kerala"){
            doc.countries[0].states[i].state = "Goa";
        }       
    }
    db.coll.save(doc);
});

Another option: This feature should be fixed in version 3.5.12, see here

hope this will help someone.

Collectives™ on Stack Overflow

Update deeply nested array element in mongodb

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related