How to get back the new value after an update in a embedded array?

by

If you are on MongoDB 3.0 or newer, you need to use the .findOneAndUpdate() and use projection option to specify the subset of fields to return. You also need to set returnNewDocument to true. Of course you need to use the $elemMatch projection operator here because you cannot use a positional projection and return the new document.

As someone pointed out:

You should be using .findOneAndUpdate() because .findAndModify() is highlighed as deprecated in every official language driver. The other thing is that the syntax and options are pretty consistent across drivers for .findOneAndUpdate(). With .findAndModify(), most drivers don’t use the same single object with “query/update/fields” keys. So it’s a bit less confusing when someone applies to another language to be consistent. Standardized API changes for .findOneAndUpdate() actually correspond to server release 3.x rather than 3.2.x. The full distinction being that the shell methods actually lagged behind the other drivers ( for once ! ) in implementing the method. So most drivers actually had a major release bump corresponding with the 3.x release with such changes.

db.collection.findOneAndUpdate( 
    { 
        "_id": ObjectId("56d6a7292c06e85687f44541"), 
         "rankings._id" : ObjectId("46d6a7292c06e85687f55543") 
    },  
    { $inc : { "rankings.$.score" : 1 } },  
    { 
        "projection": { 
            "rankings": { 
                "$elemMatch": { "_id" : ObjectId("46d6a7292c06e85687f55543") } 
            }
        }, 
        "returnNewDocument": true 
    }
)

From MongoDB 3.0 onwards, you need to use findAndModify and the fields options also you need to set new to true in other to return the new value.

db.collection.findAndModify({   
    query: { 
        "_id": ObjectId("56d6a7292c06e85687f44541"), 
        "rankings._id" : ObjectId("46d6a7292c06e85687f55543") 
    },     
    update: { $inc : { "rankings.$.score" : 1 } },       
    new: true,  
    fields: { 
        "rankings": { 
            "$elemMatch": { "_id" : ObjectId("46d6a7292c06e85687f55543") }
        }  
    }
})

Both queries yield:

{
        "_id" : ObjectId("56d6a7292c06e85687f44541"),
        "rankings" : [
                {
                        "_id" : ObjectId("46d6a7292c06e85687f55543"),
                        "name" : "Ranking 2",
                        "score" : 11
                }
        ]
}

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. How to query nested objects?
  5. Update field in exact element array in MongoDB
  6. how to convert string to numerical values in mongodb
  7. How to find MongoDB field name at arbitrary depth
  8. Return only matched sub-document elements within a nested array
  9. Converting string to date in mongodb
  10. Querying internal array size in MongoDB
  11. MongoDB wildcard in the key of a query
  12. MongoDB Full and Partial Text Search
  13. Mongodb Join on _id field from String to ObjectId
  14. Difference between count() and find().count() in MongoDB
  15. How to insert an element to MongoDB internal list?
  16. Mongo sort on a calculated condition
  17. MongoDB: Calculate dwell time between every status value change
  18. Search on multiple collections in MongoDB
  19. How to ignore nulls while unmarshalling a MongoDB document?
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. Mongodb query specific month|year not date
  23. Remove Duplicates from MongoDB
  24. How to stop insertion of Duplicate documents in a mongodb collection
  25. MongoDB nested array query
  26. How to access overall document count during arithmetic aggregation expression
  27. Push to two separate arrays in one update call in mongodb
  28. How to toggle a boolean field in one document with atomic operation?
  29. Mongodb concat int and string
  30. MongoDB $lookup on nested document

Leave a Comment