Update nested document with mutiple conditions

Question

{
    id: 1,
    name: "venkat",
    description: "Description",
    address: "chennai",
    pinCode: "600100",
    authenticationCode: "123",
    authenticated: false,
    deleted: false,
    Location: [
        {
            name: "foo",
            description: "LocationDecription",
            parent: "parent",
            UserAccess: [
                {
                    loginName: "paklon",
                    role: "role"
                }
            ]
        }
    ]
}

I need to update role:"admin" where conditions match like id: 1, Location's array name: "foo" and Location nested array of "UserAccess.loginName": "paklon" and then update the role.

Take a look at the similar [question](https://stackoverflow.com/questions/18573117/updating-nested-arrays-in-mongodb-via-mongo-shell) — Volodymyr Synytskyi, Jan 24 '17 at 15:01

Rubin Porwal · Accepted Answer · 2017-01-25T05:01:03.370

1

According to above mentioned description as a solution to it please try executing following update operation in MongoDB shell

db.collection.update({
    "id": 1,
    "Location": {
        $elemMatch: {
            "name": "foo",
            "UserAccess": {
                $elemMatch: {
                    "loginName": "paklon"
                }
            }
        }
    }
}, {
    $set: {
        "Location.$.UserAccess.0.role": "admin"
    }
})

edited Jan 25 '17 at 05:01

answered Jan 24 '17 at 12:40

Rubin Porwal

3,736
1
23
26

working thanks lot but some changes:"Location.$.UserAccess.0.role": "admin" – venkat Jan 25 '17 at 04:06

Oleks · Answer 2 · 2017-01-24T12:45:18.930

0

The following query should work:

db.collection.update(
    {"id": 1, "Location.name": "foo", "Location.UserAccess.loginName": "paklon"}, 
    {$set: {"Location.0.UserAccess.0.role": "admin"}}
)

To update a particular element in an array you need to use positional operator "$" that actually a placeholder for the first element. So it could be replaced with "0" and as it permitted using the "$" only once in the query, you will have to use "0" at the end of the query in any case.

Also take a look at a corresponding mongodb documentation

edited Jan 24 '17 at 12:45

answered Jan 24 '17 at 12:24

Oleks

1,633
1
18
22

For my knowledge can you tell me what is the significance of **0** in $set – Prashant Pokhriyal Jan 24 '17 at 12:30
@PrashantPokhriyal it is the same as "$", that is used to specify an array element to update. In background "$" converts to "0" – Oleks Jan 24 '17 at 12:37

Update nested document with mutiple conditions

2 Answers2