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
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/mongodb/shell-methods/cursor/cursor-skip.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics