Find by _id on an array of objects in MongoDB database?

To find by _id on an array of objects, use aggregation and avoid using find(). Let us first create a collection with documents −

> db.demo414.insertOne(
...    {
...       "_id": "110",
...       "details":[
...          {
...             "StudentName":"John",
...             "StudentMarks":56
...          },
...          {
...             "StudentName":"Robert",
...             "StudentMarks":98
...          }
...       ]
...    }
... );
{ "acknowledged" : true, "insertedId" : "110" }

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

> db.demo414.find();

This will produce the following output −

{ "_id" : "110", "details" : [ { "StudentName" : "John", "StudentMarks" : 56 }, { "StudentName" : "Robert", "StudentMarks" : 98 } ] }

Following is the query to find by _id on an array of objects −

> db.demo414.aggregate([{$unwind: "$details"}, {$match:{"details.StudentMarks" :56}}] )

This will produce the following output −

{ "_id" : "110", "details" : { "StudentName" : "John", "StudentMarks" : 56 } }

AmitDiwan

Published on 03-Apr-2020 13:25:20

• Related Questions & Answers
• How to find a record by _id in MongoDB?
• Get the array of _id in MongoDB?
• Sorting an array of objects by an array JavaScript
• MongoDB query to group by _id
• Creating an array of objects based on another array of objects JavaScript
• Querying on an array of objects for specific nested documents with MongoDB?
• How can I find documents in MongoDB based on the number of matched objects within an array?
• Update an array of strings nested within an array of objects in MongoDB
• Can we search an array of objects in MongoDB?
• How to search document in MongoDB by _id
• Can MongoDB find() function display avoiding _id?
• Sorting an array of objects by property values - JavaScript
• How to delete document by _id using MongoDB?
• Pull multiple objects from an array in MongoDB?
• Sort an array of objects by multiple properties in JavaScript