Multiple update of embedded documents' properties

Question

I have the following collection:

{ 
"Milestones" : [      
    {       "ActualDate" : null,   
    "Index": 0,
    "Name" : "milestone1",  
    "TargetDate" : ISODate("2011-12-13T22:00:00Z"),         
    "_id" : ObjectId("4ee89ae7e60fc615c42e28d1")},         
    {       "ActualDate" : null,    
    "Index" : 0,    
    "Name" : "milestone2",  
    "TargetDate" : ISODate("2011-12-13T22:00:00Z"),         
    "_id" : ObjectId("4ee89ae7e60fc615c42e28d2") } ]
, 
"Name" : "a", "_id" : ObjectId("4ee89ae7e60fc615c42e28ce") 
}

I want to update definite documents: that have specified _id, List of Milestones._id and ActualDate is null. I dotnet my code looks like:

var query = Query.And(new[] { Query.EQ("_id", ObjectId.Parse(projectId)),
  Query.In("Milestones._id", new BsonArray(values.Select(ObjectId.Parse))), 
 Query.EQ("Milestones.ActualDate", BsonNull.Value) });                

var update = Update.Set("Milestones.$.ActualDate", DateTime.Now.Date);    

Coll.Update(query, update, UpdateFlags.Multi, SafeMode.True);

Or in native code:

db.Projects.update({ "_id" : ObjectId("4ee89ae7e60fc615c42e28ce"), "Milestones._id" : { "$in" : [ObjectId("4ee89ae7e60fc615c42e28d1"), ObjectId("4ee89ae7e60fc615c42e28d2"), ObjectId("4ee8a648e60fc615c41d481e")] }, "Milestones.ActualDate" : null },{ "$set" : { "Milestones.$.ActualDate" : ISODate("2011-12-13T22:00:00Z") } }, false, true)

But only the first item is being updated.

score 10 · Accepted Answer · answered Dec 14 '11 at 14:06

10

This is not possible in current moment. Flag multi in update means update of multiple root documents. Positional operator can match only one nested array item. There is such feature in mongodb jira. You can vote up and wait.

Current solution can be only load document, update as you wish and save back or multiple atomic update for each nested array id.

From documentation at mongodb.org:

Currently the $ operator only applies to the first matched item in the query

answered Dec 14 '11 at 14:06

Andrew Orsich

52,935
16
139
134

Thx, Andrew. I have upvoted the issue in jira . I hope they will implement it. – 1gn1ter Dec 14 '11 at 14:22
2

@1gn1ter: this feature was approved, but not scheduled :( – Andrew Orsich Dec 14 '11 at 15:01
2

4 years later, is it supported? – mc9 Oct 08 '15 at 04:37
1

@1gn1ter Did you get any solution for this? I'm looking for the same – Kishore Kumar Korada Oct 17 '17 at 07:15

score 1 · Answer 2 · answered Apr 23 '13 at 14:15

As answered by Andrew Orsich, this is not possible for the moment, at least not as you wish. But loading the document, modifying the array then saving it back will work. The risk is that some other process could modify the array in the meantime, so you would overwrite its changes. To avoid this, you can use optimistic locking, especially if the array is not modified every second.

load the document, including a new attribute: milestones_version
modify the array as needed

save back to mongodb, but now add a query constraint on the milestones_version, and increment it:

db.Projects.findAndModify({
    query: {
        _id: your_project_id,
        milestones_version: expected_milestones_version
    },
    update: {
        $set: {
            Milestones: modified_milestones
        },
        $inc: {
            milestones_version: 1
        }
    },
    new: 1
})

If another process modified the milestones array (and hence the milestones_version) before we did, then this command will do nothing and simply return null. We just need to reload the document and try again. If the array is not modified every second, then this will be very rare and will not have any impact on performance.

The main problem with this solution is that you have to edit every Project, one by one (no multi: true). You could still write a javascript function and have it run on the server though.

score 0 · Answer 3 · answered Oct 24 '17 at 04:51

0

According to their JIRA page "This new feature is available starting with the MongoDB 3.5.12 development version, and included in the MongoDB 3.6 production version"

https://jira.mongodb.org/browse/SERVER-1243

answered Oct 24 '17 at 04:51

Hemant Kumar Goyal

132
1
2
9

Multiple update of embedded documents' properties

3 Answers3

Linked