How to get values of cursor in MongoDB?


To get values of cursor in MongoDB, use hasNext(). Let us create a collection with documents −

> db.demo191.insertOne({"EmployeeId":1,"EmployeeName":"Chris Brown"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e3ad95303d395bdc21346c5")
}
> db.demo191.insertOne({"EmployeeId":2,"EmployeeName":"David Miller"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e3ad95f03d395bdc21346c6")
}
> db.demo191.insertOne({"EmployeeId":1,"EmployeeName":"John Doe"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e3ad96803d395bdc21346c7")
}
> db.demo191.insertOne({"EmployeeId":1,"EmployeeName":"John Smith"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e3ad97003d395bdc21346c8")
}

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

> db.demo191.find();

This will produce the following output −

{ "_id" : ObjectId("5e3ad95303d395bdc21346c5"), "EmployeeId" : 1, "EmployeeName" : "Chris Brown" }
{ "_id" : ObjectId("5e3ad95f03d395bdc21346c6"), "EmployeeId" : 2, "EmployeeName" : "David Miller" }
{ "_id" : ObjectId("5e3ad96803d395bdc21346c7"), "EmployeeId" : 1, "EmployeeName" : "John Doe" }
{ "_id" : ObjectId("5e3ad97003d395bdc21346c8"), "EmployeeId" : 1, "EmployeeName" : "John Smith" }

Following is the query to get values of cursor object −

> var cursor = db.demo191.find( { "EmployeeId":1 } );
> while (cursor.hasNext()) {
...   print(tojson(cursor.next()));
...}

This will produce the following output −

{
   "_id" : ObjectId("5e3ad95303d395bdc21346c5"),
   "EmployeeId" : 1,
   "EmployeeName" : "Chris Brown"
}
{
   "_id" : ObjectId("5e3ad96803d395bdc21346c7"),
   "EmployeeId" : 1,
   "EmployeeName" : "John Doe"
}
{
   "_id" : ObjectId("5e3ad97003d395bdc21346c8"),
   "EmployeeId" : 1,
   "EmployeeName" : "John Smith"
}

Updated on: 27-Mar-2020

516 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements