How can I update the sub document field from the sub document array based on the query?

Question

{
"_id": ObjectId("552cd780e4b042752e540df5"),
"source": [
    {
        "bookid": ObjectId("552cd77e31456e192df6ad8e"),
        "isActive": false
    },
    {
        "bookid": ObjectId("552cd77e31456e192df6ad8a"),
        "isActive": true
    }
]
}

I need to update the above document , where the condition is the source.bookid is ObjectId("552cd77e31456e192df6ad8e") and update that particular document field isActive as false. So, the resulting output I need as

{
"_id": ObjectId("552cd780e4b042752e540df5"),
"source": [
    {
        "bookid": ObjectId("552cd77e31456e192df6ad8e"),
        "isActive": false
    },
    {
        "bookid": ObjectId("552cd77e31456e192df6ad8e"),
        "isActive": true
    }
]
}

Can anyone please tell me , how to execute this update query? and also is it possible to retrieve all documents where the sub docments array contains all "isActive" as false?

In your sample document, how come the `source.bookid` is the same in the `source` array? Did you mean to have distinct book ids? — chridam, Apr 16 '15 at 07:20

score 0 · Accepted Answer · answered Apr 16 '15 at 07:02

Use mongo update documentation for nesting key update use $elemMatch query as below

db.collectionName.update({"source":{"$elemMatch":{"bookid":ObjectId("552cd77e31456e192df6ad8e")}}},{"$set":{"source.$.isActive":false}})

If multiple document update then used this mongo update add multi true.

How can I update the sub document field from the sub document array based on the query?

1 Answers1

Linked