Change value in nested document in MongoDB-array

Question

I have document:

{
    "_id" : ObjectId("5152ba0708c164359d5ca616"),
        "info": "Some interesting information.",
    "elements" : [
        {
            "status" : "accepted",
            "id" : "10"
        },
                {
            "status" : "waiting",
            "id" : "20"
        },
                {
            "status" : "accepted",
            "id" : "30"
        }
    ]
}

How can I modify "status" to "accepted" where "status" is "waiting" and "id" is 20?

You do not want to check status and id at the same time ?

Devesh
– Devesh

2013-03-28 12:58:37 +00:00
Commented Mar 28, 2013 at 12:58 — Devesh
– Devesh, Commented Mar 28, 2013 at 12:58

Ebubekir Dirican · Accepted Answer · 2013-03-28 09:39:03Z

3

use positional ("$") operator.

// single
db.collection.update({ _id: ..., "elements.id": "20" }, { $set: { "elements.$.status": "status" } })

// all
db.collection.update({ "elements.id": "20" }, { $set: { "elements.$.status": "status" } }, { multi: true  })

answered Mar 28, 2013 at 9:39

Ebubekir Dirican

3864 silver badges12 bronze badges

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

2 Comments

Devesh Over a year ago

Where are you checking for the "waiting" status ? If you only check for 20 you may get those elements also where the status is already "accepted"

cgl Over a year ago

db.collection.update({ "_id": ..., "elements.id": "20" }, { "$set": { "elements.$.status": "status" } })

Devesh · Accepted Answer · 2013-03-28 09:05:48Z

1

You have to use elemMatch (http://docs.mongodb.org/manual/reference/projection/elemMatch/) . To match both the items of the array like status and id 20 , then you can use the $set command. The reason behind using elemMatch is that it will make sure that both the criteria is matched on the same subdocument before returning the result

db.CollectionName.update({"_id" : ObjectId("5152ba0708c164359d5ca616") , "elements" : { "$elemMatch : {"status" : "waiting" , "Id" : "20"}}},{ $set : {"elements.$.status" : "accepted"}});

edited Mar 28, 2013 at 9:05

answered Mar 28, 2013 at 9:00

Devesh

4,5501 gold badge20 silver badges28 bronze badges

Collectives™ on Stack Overflow

Change value in nested document in MongoDB-array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related