MongoDB query to get a specific number of items

MongoDBDatabaseBig Data Analytics

To get a specific number of items, use $slice operator in MongoDB. Let us create a collection with documents −

> db.demo48.insertOne({"Name":["David","Chris","Sam","Mike","Carol"]});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e270491cfb11e5c34d89901")
}

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

> db.demo48.find();

This will produce the following output −

{ "_id" : ObjectId("5e270491cfb11e5c34d89901"), "Name" : [ "David", "Chris", "Sam", "Mike", "Carol" ] }

Following is the query to get only 2 items −

> db.demo48.find({},{Name:{$slice: 2}});

This will produce the following output −

{ "_id" : ObjectId("5e270491cfb11e5c34d89901"), "Name" : [ "David", "Chris" ] }
raja
Published on 03-Apr-2020 15:54:47
Advertisements