Menu
{ "_id": "xPBc4By8FemDwTPqH", "u": { "_id": "6PoZawHZcQz4Gwzcv", "username": "michael" }, "friends": [ { "u": { "_id": "eGqDjAjjtYADbuSnn", "username": "michael", "name": "michael" } }, { "u": { "_id": "k4gKCGwYryXDMMHvs", "username": "joyce", "name": "joyce" } } ] } I want to update the name of "friends.u.username": "michael" 's name is "hello", how I need to do it.
333
Update Nested Arrays in Conjunction with $[] The $[<identifier>] filtered positional operator, in conjunction with the $[] all positional operator, can be used to update nested arrays. The following updates the values that are greater than or equal to 8 in the nested grades. questions array if the associated grades.
MongoDB syntax for updating an object inside an array within a document? For this, use findOneAndUpdate() in MongoDB. The findOneAndUpdate() method updates a single document based on the filter and sort criteria.
To update more than one array item matching the criteria in this way, then you need to issue the update several times until the document is no longer modified. So the index position is 0 for the first element, 1 for the second element and so on.
Apply the $set operator together with the $ positional operator in your update to change the name field.
The $ positional operator will identify the correct element in the array to update without explicitly specifying the position of the element in the array, thus your final update statement should look like:
db.collection.update( { "friends.u.username": "michael" }, { "$set": { "friends.$.u.name": "hello" } } ) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
