How to update an array of multiple elements in mongodb..?

Question

I have a requirement to update an array of multiple elements.My collections is in the following way

{
"_id" : ObjectId("53e87e239ae974e6a0a81004"),
"name" : "mulagala",
"notifications" : [
    {
        "name" : "apple",
        "status" : 0
    },
    {
        "name" : "microsoft",
        "status" : 0
    },
    {
        "name" : "android",
        "status" : 0
    }
]
}

now i want to change the every status element of the array should be changed to 1, ie.status:1 with a single query.

I tried in the following way

db.mystatus.update({'notifications.status':0},{$set:{'notifications.$.status':1}},false,true)

But the first record only updating, what to do.Any help would be appriciated!

This is a duplicate of this question. Short answer is that this cannot be done using the positional operator $. There's this issue in JIRA you should vote for if you want this implemented. Answer in other question gives you an idea of how to go around this issue. — Juan Carlos Farah
– Juan Carlos Farah, Commented Aug 11, 2014 at 13:58

Saket · Accepted Answer · 2014-08-11 09:53:07Z

1

Have you tried updating the elements of the array using the $ operator for arrays? Currently it updates only one element as the index is coded to 0.

answered Aug 11, 2014 at 9:53

Saket

3,1393 gold badges32 silver badges51 bronze badges

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

2 Comments

Mulagala Over a year ago

@Seket, Tried that one also, but like you said only one element is updating, i need to update all the elements in the list

Juan Carlos Farah Over a year ago

@Seket, this won't work because the positional $ operator only matches the first element that matches the query document. For more info, see here.

Collectives™ on Stack Overflow

How to update an array of multiple elements in mongodb..?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related