w3resource

MongoDB: cursor.skip() method

cursor.skip

The cursor.skip() method is used to return a cursor that begins returning results only after passing or skipping a number of documents.

Syntax:

cursor.skip()

Sample document in the restaurants collection:


{
  "address": {
     "building": "1007",
     "coord": [ -73.856077, 40.848447 ],
     "street": "Morris Park Ave",
     "zipcode": "10462"
  },
  "borough": "Bronx",
  "cuisine": "Bakery",
  "grades": [
     { "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 },
     { "date": { "$date": 1378857600000 }, "grade": "A", "score": 6 },
     { "date": { "$date": 1358985600000 }, "grade": "A", "score": 10 },
     { "date": { "$date": 1322006400000 }, "grade": "A", "score": 9 },
     { "date": { "$date": 1299715200000 }, "grade": "B", "score": 14 }
  ],
  "name": "Morris Park Bake Shop",
  "restaurant_id": "30075445"
}
........

Example: MongoDB: cursor.skip() method

The following example will return a cursor that begins returning results for only 5 documents after passing or skipping 12 of documents.

db.restaurants.find({"cuisine" : "American "}).limit(5).skip(12);

Output:

> db.restaurants.find({"cuisine" : "American "}).limit(5).skip(12);
{ "_id" : ObjectId("55c3043ab165fa6355ec5cad"), "address" : { "building" : "625", "coord" : [ -73.990494, 40.7569545 ], "street" : "8 Avenue", "zipcode" : "10018" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-06-09T00:00:00Z"), "grade" : "A", "score" : 12
 }, { "date" : ISODate("2014-01-10T00:00:00Z"), "grade" : "A", "score" : 9 }, { "date" : ISODate("2012-12-07T00:00:00Z"), "grade" : "A", "score" : 4 }, { "date" : ISODate("2011-12-13T00:00:00Z"), "grade" : "A", "score" : 9 }, { "date" : ISODate("2011-09-09T00:00:00Z"), "grade" : "A", "score" : 13 }
], "name" : "Cafe Metro", "restaurant_id" : "40363298" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cb2"), "address" : { "building" : "87-69", "coord" : [ -73.8309503, 40.7001121 ], "street" : "Lefferts Boulevard", "zipcode" : "11418" }, "borough" : "Queens", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-02-25T00:00:00Z"), "grade" : "A", "s
core" : 7 }, { "date" : ISODate("2013-08-14T00:00:00Z"), "grade" : "A", "score" : 11 }, { "date" : ISODate("2012-08-07T00:00:00Z"), "grade" : "A", "score" : 7 }, { "date" : ISODate("2012-03-26T00:00:00Z"), "grade" : "A", "score" : 10 }, { "date" : ISODate("2011-11-04T00:00:00Z"), "grade" : "A", "sco
re" : 0 }, { "date" : ISODate("2011-06-29T00:00:00Z"), "grade" : "A", "score" : 4 } ], "name" : "Snack Time Grill", "restaurant_id" : "40363590" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cb5"), "address" : { "building" : "437", "coord" : [ -73.975393, 40.757365 ], "street" : "Madison Avenue", "zipcode" : "10022" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-06-03T00:00:00Z"), "grade" : "A", "score"
 : 9 }, { "date" : ISODate("2013-06-07T00:00:00Z"), "grade" : "A", "score" : 5 }, { "date" : ISODate("2012-06-29T00:00:00Z"), "grade" : "A", "score" : 12 }, { "date" : ISODate("2012-02-06T00:00:00Z"), "grade" : "A", "score" : 11 }, { "date" : ISODate("2011-06-23T00:00:00Z"), "grade" : "A", "score" :
 13 } ], "name" : "Berkely", "restaurant_id" : "40363685" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cb6"), "address" : { "building" : "1031", "coord" : [ -73.9075537, 40.6438684 ], "street" : "East   92 Street", "zipcode" : "11236" }, "borough" : "Brooklyn", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-02-05T00:00:00Z"), "grade" : "A", "sc
ore" : 0 }, { "date" : ISODate("2013-01-29T00:00:00Z"), "grade" : "A", "score" : 3 }, { "date" : ISODate("2011-12-08T00:00:00Z"), "grade" : "A", "score" : 10 } ], "name" : "Sonny'S Heros", "restaurant_id" : "40363744" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cba"), "address" : { "building" : "364", "coord" : [ -73.96084119999999, 40.8014307 ], "street" : "West  110 Street", "zipcode" : "10025" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-09-04T00:00:00Z"), "grade" : "
B", "score" : 20 }, { "date" : ISODate("2014-02-26T00:00:00Z"), "grade" : "B", "score" : 23 }, { "date" : ISODate("2013-03-25T00:00:00Z"), "grade" : "A", "score" : 12 }, { "date" : ISODate("2012-02-21T00:00:00Z"), "grade" : "A", "score" : 8 } ], "name" : "Spoon Bread Catering", "restaurant_id" : "40
364179" }

The following example will return a cursor that begins returning results for only 5 documents after passing or skipping 14 of documents.

db.restaurants.find({"cuisine" : "American "}).limit(5).skip(14);

Output:

> db.restaurants.find({"cuisine" : "American "}).limit(5).skip(14);
{ "_id" : ObjectId("55c3043ab165fa6355ec5cb5"), "address" : { "building" : "437", "coord" : [ -73.975393, 40.757365 ], "street" : "Madison Avenue", "zipcode" : "10022" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-06-03T00:00:00Z"), "grade" : "A", "score"
 : 9 }, { "date" : ISODate("2013-06-07T00:00:00Z"), "grade" : "A", "score" : 5 }, { "date" : ISODate("2012-06-29T00:00:00Z"), "grade" : "A", "score" : 12 }, { "date" : ISODate("2012-02-06T00:00:00Z"), "grade" : "A", "score" : 11 }, { "date" : ISODate("2011-06-23T00:00:00Z"), "grade" : "A", "score" :
 13 } ], "name" : "Berkely", "restaurant_id" : "40363685" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cb6"), "address" : { "building" : "1031", "coord" : [ -73.9075537, 40.6438684 ], "street" : "East   92 Street", "zipcode" : "11236" }, "borough" : "Brooklyn", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-02-05T00:00:00Z"), "grade" : "A", "sc
ore" : 0 }, { "date" : ISODate("2013-01-29T00:00:00Z"), "grade" : "A", "score" : 3 }, { "date" : ISODate("2011-12-08T00:00:00Z"), "grade" : "A", "score" : 10 } ], "name" : "Sonny'S Heros", "restaurant_id" : "40363744" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cba"), "address" : { "building" : "364", "coord" : [ -73.96084119999999, 40.8014307 ], "street" : "West  110 Street", "zipcode" : "10025" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-09-04T00:00:00Z"), "grade" : "
B", "score" : 20 }, { "date" : ISODate("2014-02-26T00:00:00Z"), "grade" : "B", "score" : 23 }, { "date" : ISODate("2013-03-25T00:00:00Z"), "grade" : "A", "score" : 12 }, { "date" : ISODate("2012-02-21T00:00:00Z"), "grade" : "A", "score" : 8 } ], "name" : "Spoon Bread Catering", "restaurant_id" : "40
364179" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cbc"), "address" : { "building" : "0", "coord" : [ -84.2040813, 9.9986585 ], "street" : "Guardia Airport Parking", "zipcode" : "11371" }, "borough" : "Queens", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-05-16T00:00:00Z"), "grade" : "A", "s
core" : 9 }, { "date" : ISODate("2013-05-10T00:00:00Z"), "grade" : "A", "score" : 10 }, { "date" : ISODate("2012-05-15T00:00:00Z"), "grade" : "A", "score" : 9 }, { "date" : ISODate("2011-11-02T00:00:00Z"), "grade" : "C", "score" : 32 } ], "name" : "Terminal Cafe/Yankee Clipper", "restaurant_id" : "4
0364262" }
{ "_id" : ObjectId("55c3043ab165fa6355ec5cc3"), "address" : { "building" : "1", "coord" : [ -73.97166039999999, 40.764832 ], "street" : "East   60 Street", "zipcode" : "10022" }, "borough" : "Manhattan", "cuisine" : "American ", "grades" : [ { "date" : ISODate("2014-10-16T00:00:00Z"), "grade" : "B",
 "score" : 24 }, { "date" : ISODate("2014-05-02T00:00:00Z"), "grade" : "A", "score" : 4 }, { "date" : ISODate("2013-04-02T00:00:00Z"), "grade" : "A", "score" : 13 }, { "date" : ISODate("2012-10-19T00:00:00Z"), "grade" : "A", "score" : 12 }, { "date" : ISODate("2012-04-27T00:00:00Z"), "grade" : "B",
"score" : 17 }, { "date" : ISODate("2011-11-29T00:00:00Z"), "grade" : "A", "score" : 11 } ], "name" : "Metropolitan Club", "restaurant_id" : "40364347" }

Retrieve the restaurants data from here

Previous: cursor.size() method
Next: cursor.sort() method



Inviting useful, relevant, well-written and unique guest posts