MongoDB function to return a specific data/value?

To return a specific data, use findOne() in MongoDB. The findOne() method returns one document that satisfies the specified query criteria on the collection Let us create a collection with documents −

> db.demo473.insertOne(
... {
...    "_id" : new ObjectId(),
...    "Name" : "Chris",
...    "details" : {
...       "X-Coordinate" :10,
...       "Y-Coordinate" :15
...    }
... }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e805a07b0f3fa88e227907d")
}
> db.demo473.insertOne(
... {
...    "_id" : new ObjectId(),
...    "Name" : "Bob",
...    "details" : {
...       "X-Coordinate" :11,
...       "Y-Coordinate" :12
...    }
... }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e805a07b0f3fa88e227907e")
}

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

> db.demo473.find();

This will produce the following output −

{ "_id" : ObjectId("5e805a07b0f3fa88e227907d"), "Name" : "Chris", "details" : { "X-Coordinate"
: 10, "Y-Coordinate" : 15 } }
{ "_id" : ObjectId("5e805a07b0f3fa88e227907e"), "Name" : "Bob", "details" : { "X-Coordinate" :
11, "Y-Coordinate" : 12 } }

Following is the query to return a specific data with MongoDB findOne() function −

> db.demo473.findOne({ 'details.X-Coordinate':11 })

This will produce the following output −

{
   "_id" : ObjectId("5e805a07b0f3fa88e227907e"),
   "Name" : "Bob",
   "details" : {
      "X-Coordinate" : 11,
      "Y-Coordinate" : 12
   }
}

AmitDiwan

Published on 11-May-2020 09:43:17

• Related Questions & Answers
• Return a specific field in MongoDB?
• Return specific MongoDB embedded document
• Find value above a specific value in MongoDB documents?
• MongoDB query to pull a specific value from a document
• How to return a value from a JavaScript function?
• Update only a specific value in a MongoDB document
• MongoDB query to return specific fields from an array?
• MongoDB query to increment a specific value using custom variable
• MongoDB query (aggregation framework) to match a specific field value
• Query an array in MongoDB to fetch a specific value
• Specify a return format for data in MongoDB
• How to return only value of a field in MongoDB?
• Get the count of a specific value in MongoDB
• MongoDB query to determine if a specific value does not exist?
• How to read a specific key-value pair from a MongoDB collection?