Update array of document embedded

Question

A question if I want to update all documents embedded in a document, how could I do? because when you run the following command

.update({'sites':{$elemMatch:{'status':true}}},{$set:{'sites.$.status': false}},{multi:true})

only the first found embedded document is updated

documents example:

{
  '_id': 1, 
  sites: [

    {'status':true,'url':'http://google.com'},
    {'status':true,'url':'https://university.mongodb.com'},
    {'status':true,'url':'https://docs.mongodb.org'}
]}

It is not possible right now. You can read workaround here: How to Update Multiple Array Elements in mongodb . There is an open Issue in MongoDB for that feature: jira.mongodb.org/browse/SERVER-1243 — Bonanza
– Bonanza, Commented Mar 23, 2016 at 20:31

BanksySan · Accepted Answer · 2016-03-23 21:08:36Z

1

This isn't possible, the closes you can get is to update the entire element. e.g.:

db.test.update({
    _id: 1
},
{
    $set: {
        sites: [
            {'status':true,'url':'http://1.example.com'},
            {'status':true,'url':'http://2.example.com'},
            {'status':true,'url':'http://3.example.com'},
        ]
    }
})

answered Mar 23, 2016 at 21:08

BanksySan

28.7k36 gold badges128 silver badges231 bronze badges

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

1 Comment

Blakes Seven Over a year ago

This is exactly what a statement I gave in answer to How to Update Multiple Array Elements in mongodb warns people not to do: 'Do not "one shot" update the array'. Whilst that practice may be acceptable in a data transformation with no update traffic, it is not safe to presume that the array members you "thought" were the only ones present at the time of issuing the update are "still" the only array members, or indeed in the same order ( should order be important, and also covered with another point ). You should read this yourself.

Collectives™ on Stack Overflow

Update array of document embedded

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related