To return a single document from a collection, use findOne() in MongoDB. Let us create a collection with documents −> db.demo463.insertOne({"StudentName":"Chris Brown", "StudentAge":21, "StudentCountryName":"US"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7f7ec8cb66ccba22cc9dcf") } > db.demo463.insertOne({"StudentName":"David Miller", "StudentAge":23, "StudentCountryName":"UK"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7f7ed5cb66ccba22cc9dd0") } > db.demo463.insertOne({"StudentName":"John Doe", "StudentAge":22, "StudentCountryName":"AUS"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7f7ee1cb66ccba22cc9dd1") } > db.demo463.insertOne({"StudentName":"John Smith", "StudentAge":24, "StudentCountryName":"US"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7f7eefcb66ccba22cc9dd2") }Display all documents from a collection with the help of find() method −> db.demo463.find();This will produce the following output −{ "_id" : ObjectId("5e7f7ec8cb66ccba22cc9dcf"), "StudentName" : "Chris ... Read More

To update a specific document in array with $set and positional $ operator, use MongoDB updateOne(). The updateOne() updates a single document in a collection based on a query filter.Let us create a collection with documents −> db.demo462.insertOne( ... { ...    "id":1, ...    "DueDateDetails": [ ...       { ...          "Name": "David", ...          "Age":21, ...          "CountryName":["US", "UK"] ...       }, ...       { ... ...          "Name": "Chris", ...          "Age":23, ...       ... Read More

To update tag in MongoDB, use the update command. Let us create a collection with documents −> db.demo713.insertOne( ... { ... tags: ...    [ ...       { ...          id:101, ...          Name:"Tag-1" ...       }, ...       { ...          id:102, ...          Name:"Tag-3" ...       }, ...       { ...          id:103, ...          Name:"Tag-3" ...       } ...    ] ... } ... ); {   ... Read More

To cast to ObjectId correctly, use aggregate() in MongoDB. Let us create a collection with documents −> db.demo460.insertOne({"_id":"5ab9cbfa31c2ab715d42129e"}); { "acknowledged" : true, "insertedId" : "5ab9cbfa31c2ab715d42129e" }Display all documents from a collection with the help of find() method −> db.demo460.find();This will produce the following output −{ "_id" : "5ab9cbfa31c2ab715d42129e" }Following is the query to cast to objectId −> db.demo460.aggregate( [ idConvert ]) This will produce the following output −{ "_id" : "5ab9cbfa31c2ab715d42129e", "value" : ObjectId("5ab9cbfa31c2ab715d42129e") }

To get items from an object array, use aggregate(). Let us create a collection with documents −> db.demo459.insertOne( ... { "_id" : 1, ... "Information" : [ ...    { ...       "Name" : "Chris", ...       "_id" : new ObjectId(), ...       "details" : [ ...          "HR" ...       ] ...    }, ... { ... ...    "Name" : "David", ...    "_id" : new ObjectId(), ...    "details" : [ ...       "Developer" ...    ] ... }, ... { ... ...   ... Read More

To update a record, you need to update on the basis of _id. Let us create a collection with documents −> db.demo458.insertOne( {_id:101, "Name":"David" } ); { "acknowledged" : true, "insertedId" : 101 } > db.demo458.insertOne( {_id:102, "Name":"Chris" } ); { "acknowledged" : true, "insertedId" : 102 } > db.demo458.insertOne( {_id:103, "Name":"Bob" } ); { "acknowledged" : true, "insertedId" : 103 }Display all documents from a collection with the help of find() method −> db.demo458.find();This will produce the following output −{ "_id" : 101, "Name" : "David" } { "_id" : 102, "Name" : "Chris" } { "_id" : 103, ... Read More

For this, use $project in MongoDB. Within that, use $filter. Let us create a collection with documents −> db.demo457.insertOne( ... { ...    _id: 101, ...    details: [ ...       { ProductName:"Product-1" , ProductPrice:90 }, ...       { ProductName:"Product-2" , ProductPrice:190 } ...    ] ... } ... ); { "acknowledged" : true, "insertedId" : 101 } > > db.demo457.insertOne( ... { ...    _id: 102, ...    details: [ ...       { ProductName:"Product-3" , ProductPrice:150}, ...       { ProductName:"Product-4" , ProductPrice:360 } ...    ] ... } ... ); { ... Read More

For this, use $group in MongoDB. Within that, use $unwind, $group, $addToSet, etc. Let us create a collection with documents −> db.demo456.insertOne( ... { _id: 101, StudentName: ["Chris", "David"] } ... ); { "acknowledged" : true, "insertedId" : 101 } > > db.demo456.insertOne( ... { _id: 102, StudentName: ["Mike", "Sam"] } ... ); { "acknowledged" : true, "insertedId" : 102 } > db.demo456.insertOne( ... { _id: 103, StudentName: ["John", "Jace"] } ... ); { "acknowledged" : true, "insertedId" : 103 } > db.demo456.insertOne( ... { _id: 104, StudentName: ["Robert", "John"] } ... ); { "acknowledged" : true, "insertedId" : 104 ... Read More

To display a list of objects based on a specific property, use dot notation in find(). Let us create a collection with documents −> db.demo455.insertOne({"Information":{"Student":[{"Name":"Chris", "Age":22}]}});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7e1876dbcb9adb296c95c5") } > db.demo455.insertOne({"Information":{"Student":[{"Name":"David", "Age":21}]}});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7e1883dbcb9adb296c95c6") } > db.demo455.insertOne({"Information":{"Student":[{"Name":"Bob", "Age":24}]}});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7e188adbcb9adb296c95c7") } > db.demo455.insertOne({"Information":{"Student":[{"Name":"Robert", "Age":21}]}});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7e18bcdbcb9adb296c95c8") }Display all documents from a collection with the help of find() method −> db.demo455.find();This will produce the following output −{ "_id" : ObjectId("5e7e1876dbcb9adb296c95c5"), "Information" : { "Student" : [ { ... Read More

To publish the latest N records with sorting, use sort() along with limit(). Here, set the number of records you want to show with limit(). Let us create a collection with documents −> db.demo454.insertOne({"ClientName":"Chris"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7cce8cdbcb9adb296c95c0") } > db.demo454.insertOne({"ClientName":"John"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7cce95dbcb9adb296c95c1") } > db.demo454.insertOne({"ClientName":"Bob"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7cce9fdbcb9adb296c95c2") } > db.demo454.insertOne({"ClientName":"David"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7ccea6dbcb9adb296c95c3") } > db.demo454.insertOne({"ClientName":"Mike"});{    "acknowledged" : true,    "insertedId" : ObjectId("5e7cceafdbcb9adb296c95c4") }Display all documents from a collection with the help of find() method −> db.demo454.find();This ... Read More