Skip Returned Results

Overview

In this guide, you can learn how to skip a specified number of returned results from read operations with the MongoDB Java driver.

You can skip results on the returned results of a query by using the skip() method. You can also skip documents at a specific stage in an aggregation pipeline by specifying a $skip aggregation stage.

The skip() method takes an integer that specifies the number of documents to omit from the beginning of the list of documents returned by the FindIterable.

You can use the skip() method to skip the first two documents as follows:

collection.find().skip(2);

Aggregates.skip() is an optional stage in the aggregation pipeline that specifies how many documents to omit from the beginning of the results of the prior stage.

You can use the Aggregates.skip() method to skip the first two documents as follows:

import com.mongodb.client.model.Aggregates;
collection.aggregate(Arrays.asList(Aggregates.match(), Aggregates.skip(2)));

Examples

The following example is about a paint store that sells eight different colors of paint. The best colors sell quicker than the other colors. One day, a customer asks what the three best-selling (lowest inventory) colors are. The paint store keeps track of inventory in the qty field in their paint_inventory collection:

{ "_id": 1, "color": "red", "qty": 5 }
{ "_id": 2, "color": "purple", "qty": 10 }
{ "_id": 3, "color": "blue", "qty": 9 }
{ "_id": 4, "color": "white", "qty": 6 }
{ "_id": 5, "color": "yellow", "qty": 11 }
{ "_id": 6, "color": "pink", "qty": 3 }
{ "_id": 7, "color": "green", "qty": 8 }
{ "_id": 8, "color": "orange", "qty": 7 }

To address the scenario, the paint store needs to query the paint_inventory collection with an empty filter, sort the documents by qty field and omit the first five results.

import com.mongodb.client.model.Filters;
import com.mongodb.client.model.Sorts;
// Add your MongoCollection setup code here
Bson filter = Filters.empty();
collection.find(filter)             
    .sort(Sorts.descending("qty"))        
    .skip(5)                       
    .forEach(doc -> System.out.println(doc.toJson()));

import com.mongodb.client.model.Filters;
import com.mongodb.client.model.Sorts;
import com.mongodb.client.model.Aggregates;
// Add your MongoCollection setup code here
Bson filter = Filters.empty();
collection.aggregate(Arrays.asList(
    Aggregates.match(filter), 
    Aggregates.sort(Sorts.descending("qty")), 
    Aggregates.skip(5)))
    .forEach(doc -> System.out.println(doc.toJson())); 

{ "_id": 4, "color": "white", "qty": 6 }
{ "_id": 1, "color": "red", "qty": 5 }
{ "_id": 6, "color": "pink", "qty": 3 }

Bson filter = Filters.empty();
collection.find(filter)             
    .sort(Sorts.descending("qty"))        
    .skip(9)                       
    .forEach(doc -> System.out.println(doc.toJson()));