Is it possible to return a list of specific values from a MongoDB query?

Yes, using map(). Let us first create a collection with documents −

> dblistOfSpecificValuesDemoinsertOne({"StudentName":"John"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cefcc8fef71edecf6a1f6bb")
}
> dblistOfSpecificValuesDemoinsertOne({"StudentName":"Chris"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cefcc94ef71edecf6a1f6bc")
}
> dblistOfSpecificValuesDemoinsertOne({"StudentName":"Robert"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cefcc98ef71edecf6a1f6bd")
}
> dblistOfSpecificValuesDemoinsertOne({"StudentName":"David"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cefcc9cef71edecf6a1f6be")
}

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

> dblistOfSpecificValuesDemofind();

Output

{ "_id" : ObjectId("5cefcc8fef71edecf6a1f6bb"), "StudentName" : "John" }
{ "_id" : ObjectId("5cefcc94ef71edecf6a1f6bc"), "StudentName" : "Chris" }
{ "_id" : ObjectId("5cefcc98ef71edecf6a1f6bd"), "StudentName" : "Robert" }
{ "_id" : ObjectId("5cefcc9cef71edecf6a1f6be"), "StudentName" : "David" }

Following is the query to return a list of specific values from a query −

> dblistOfSpecificValuesDemofind()map(function(myDocument){ return myDocumentStudentName });

Output

[ "John", "Chris", "Robert", "David" ]

Chandu yadav

Published on 14-Jun-2019 11:03:18

• Related Questions & Answers
• Is it possible to return a list of specific values from a query in MongoDB?
• Is it possible to cast in a MongoDB Query?
• Is it possible to make a case-insensitive query in MongoDB?
• MongoDB query to return specific fields from an array?
• Filter specific values from a MongoDB document
• MongoDB query to update a specific document from a collection
• MongoDB query to pull a specific value from a document
• Is it possible to calculate a correlation in a MySQL query?
• MongoDB query to get specific list of names from documents where the value of a field is an array
• MongoDB query to find a specific city record from a collection
• Return a specific field in MongoDB?
• Is it possible to achieve a slice chain in MongoDB?
• MongoDB inverse of query to return all items except specific documents?
• MongoDB query to 'sort' and display a specific number of values
• MongoDB query to add up the values of a specific field in documents