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.

Let us create a collection with documents −

> db.demo553.insertOne(
... {
...    id:101,
...    "Name":"John",
...    midExamDetails:
...    [
...       {"SubjectName":"MySQL","Marks":70},
...       {"SubjectName":"MongoDB","Marks":35}
...    ]
... }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e8e3da19e5f92834d7f05ed")
}

Display all documents from a collection with the help of find() method −

> db.demo553.find();

This will produce the following output −

{ "_id" : ObjectId("5e8e3da19e5f92834d7f05ed"), "id" : 101, "Name" : "John", "midExamDetails" : [
   { "SubjectName" : "MySQL", "Marks" : 70 },
   { "SubjectName" : "MongoDB", "Marks" : 35 } 
] }

Following is the query to the syntax for updating an object inside an array within a MongoDB document −

> db.demo553.findOneAndUpdate(
...    { id:101,
...       "midExamDetails.SubjectName":"MongoDB"
...    },
...    { $set:{
...       'midExamDetails.$.Marks': 97
...    }
... }
... );
{
   "_id" : ObjectId("5e8e3da19e5f92834d7f05ed"),
   "id" : 101,
   "Name" : "John",
   "midExamDetails" : [
      {
         "SubjectName" : "MySQL",
         "Marks" : 70
      },
      {
         "SubjectName" : "MongoDB",
         "Marks" : 35
      }
   ]
}

Display all documents from a collection with the help of find() method −

> db.demo553.find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5e8e3da19e5f92834d7f05ed"),
   "id" : 101,
   "Name" : "John",
   "midExamDetails" : [
      {
         "SubjectName" : "MySQL",
         "Marks" : 70
      },
      {
         "SubjectName" : "MongoDB",
         "Marks" : 97
      }
   ]
}

AmitDiwan

Published on 14-May-2020 07:58:32

• Related Questions & Answers
• MongoDB query to find data from an array inside an object?
• Updating an array with $push in MongoDB
• How to get the matching document inside an array in MongoDB?
• Get array items inside a MongoDB document?
• How to project specific fields from a document inside an array in Mongodb?
• Updating nested document in MongoDB
• How to insert an item to an array that is inside an object in MongoDB?
• MongoDB query for Partial Object in an array
• How to push new items to an array inside of an object in MongoDB?
• Update elements inside an array in MongoDB?
• Query a nested field within an array with MongoDB
• How to get a specific object from array of objects inside specific MongoDB document?
• Add a field to an embedded document in an array in MongoDB?
• How to update a MongoDB document for adding a new item to an array?
• Updating sub-object in MongoDB?