Display MongoDB records by ObjectId?

Let us first create a collection with documents −

> db.findByObjectIdDemo.insertOne({"ClientName":"Larry","ClientAge":23});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd68cd657806ebf1256f11a")
}
> db.findByObjectIdDemo.insertOne({"ClientName":"Chris","ClientAge":26});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd68cdc57806ebf1256f11b")
}
> db.findByObjectIdDemo.insertOne({"ClientName":"David","ClientAge":38,"isMarried":true});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd68cf657806ebf1256f11c")
}

Following is the query to display all documents from a collection with the help of find() method −

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

This will produce the following output −

{
   "_id" : ObjectId("5cd68cd657806ebf1256f11a"),
   "ClientName" : "Larry",
   "ClientAge" : 23
}
{
   "_id" : ObjectId("5cd68cdc57806ebf1256f11b"),
   "ClientName" : "Chris",
   "ClientAge" : 26
}
{
   "_id" : ObjectId("5cd68cf657806ebf1256f11c"),
   "ClientName" : "David",
   "ClientAge" : 38,
   "isMarried" : true
}

Following is the query to find by ObjectId −

> db.findByObjectIdDemo.find({_id: new ObjectId("5cd68cf657806ebf1256f11c")}).toArray(function(err, myDocument) { console.log(myDocument); });

This will produce the following output −

[
   {
      "_id" : ObjectId("5cd68cf657806ebf1256f11c"),
      "ClientName" : "David",
      "ClientAge" : 38,
      "isMarried" : true
   }
]

Nishtha Thakur

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• How to generate ObjectID in MongoDB?
• Convert string to objectid in MongoDB?
• Display records by grouping dates in MySQL
• Display the undefined and exact MongoDB document records
• Find a document with ObjectID in MongoDB?
• How to convert ObjectId to string in MongoDB
• MongoDB query to convert from ObjectId to String
• Create ObjectId in MongoDB using a seed string?
• Cast to ObjectId failed for value in MongoDB?
• MySQL query to display records ordered by numeric difference?
• MongoDB query to update a MongoDB row with only the objectid
• MongoDB regex to display records whose first five letters are uppercase?
• MySQL query to display records ordered by DESC while skipping some?
• How we can perform sort on ObjectId column in MongoDB?
• Use ObjectId under findOne() to fetch a specific record in MongoDB?