How to update field in document sub-array in mongo

Question

In a database with these documents

{
        "_id" : ObjectId("5448f241e47010336375bb21"),
        "lid" : "Ridali",
        "items" : [
                {
                        "product" : "dogfood",        ,
                        "done" : false
                }
        ],
}
{
        "_id" : ObjectId("5448fc15e47010336375bb23"),
        "lid" : "Qitula",
        "items" : [
                {
                        "product" : "measure kitchen cab",
                        "done" : false,
                        "tags" : [
                                "11x30"
                        ]
                },
                {
                        "product" : "radiators",
                        "done" : true
                },
                {
                        "product" : "dogfood",
                        "done" : true
                }                
        ],
}

How would I update dogfood to catfood for lid:"Qitula" ? I have tried variations of

db.lists.update({lid: "Qitula","items: {$elemMatch: {product: "dogfood"}}},{$set: {"items.product": "catfood"}})

without success.

Abhay PS · Accepted Answer · 2015-02-21 15:52:38Z

2

db.lists.update({lid: "Qitula","items.product": "dogfood" }, { $set : { "items.$.product" : "catfood" }})

Check documentation - http://docs.mongodb.org/manual/reference/operator/update/positional/#up.S

answered Feb 21, 2015 at 15:52

Abhay PS

4,2055 gold badges29 silver badges32 bronze badges

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

Comments

Sede · Accepted Answer · 2015-02-21 15:53:00Z

1

To update subdocument you need to use the positional $ operator

db.lists.update({
    lid: "Qitula",
    items: {$elemMatch: {product: "dogfood"}}
    }, 
    {$set: {"items.$.product": "catfood"}
})

answered Feb 21, 2015 at 15:53

Sede

61.5k20 gold badges158 silver badges162 bronze badges

Collectives™ on Stack Overflow

How to update field in document sub-array in mongo

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related