Update field in exact element array in MongoDB

by

You need to make use of 2 concepts: mongodb’s positional operator and simply using the numeric index for the entry you want to update.

The positional operator allows you to use a condition like this:

{"heroes.nickname": "test"}

and then reference the found array entry like so:

{"heroes.$  // <- the dollar represents the first matching array key index

As you want to update the 2nd array entry in “items”, and array keys are 0 indexed – that’s the key 1.

So:

> db.denis.insert({_id:"43434", heroes : [{ nickname : "test",  items : ["", "", ""] }, { nickname : "test2", items : ["", "", ""] }]});
> db.denis.update(
    {"heroes.nickname": "test"}, 
    {$set: {
        "heroes.$.items.1": "new_value"
    }}
)
> db.denis.find()
{
    "_id" : "43434", 
    "heroes" : [
        {"nickname" : "test", "items" : ["", "new_value", "" ]},
        {"nickname" : "test2", "items" : ["", "", "" ]}
    ]
}

More Related Contents:

  1. Querying internal array size in MongoDB
  2. MongoDB lookup when foreign field is an array of objects
  3. How to stop insertion of Duplicate documents in a mongodb collection
  4. MongoDB nested array query
  5. Group result by 15 minutes time interval in MongoDb
  6. Random record from MongoDB
  7. MongoDB: How to update multiple documents with a single command?
  8. Moongoose aggregate $match does not match id’s
  9. How to join multiple collections with $lookup in mongodb
  10. Check if every element in array matches condition
  11. How can I get a random record from MongoDB?
  12. Include all existing fields and add new fields to document
  13. Matching ObjectId to String for $graphLookup
  14. mongodb count num of distinct values per field/key
  15. Mongodb aggregation lookup with conditions
  16. How to get back the Original document back after aggregation
  17. Get the latest record from mongodb collection
  18. What is a Cursor in MongoDB?
  19. Get n-th element of an array in MongoDB
  20. Pull and addtoset at the same time with mongo
  21. How do I rename fields when performing search/projection in MongoDB?
  22. How does MongoDB order their docs in one collection? [duplicate]
  23. mongodb aggregation framework match by nested documents
  24. Efficient paging in MongoDB using mgo
  25. How to get back the new value after an update in a embedded array?
  26. count array occurrences across all documents with mongo
  27. How can I sort a Meteor collection by time of insertion?
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment