How to achieve pagination in java mongodb aggregation

[goutham gowda]

This is my query

DBCollection coll = this.mongoTemplate.getCollection("profileInterest");

        DBObject project = new BasicDBObject("$project", new BasicDBObject("_id", 1).append("fromProfile", 1).append("toProfile", 1)

                .append("isContactNoViewed", 1).append("isShortListed", 1)

                .append("interestStatusTotal", new BasicDBObject("$size", "$interestStatus"))

                .append("interestStatus", new BasicDBObject("$slice", new Object[] { "$interestStatus", 1 })));

        DBObject match = new BasicDBObject("$match", new BasicDBObject("threeFavorites.id", new BasicDBObject("$ne", 100)));

        @SuppressWarnings("deprecation")

        AggregationOutput output = coll.aggregate(project, match);

[Dwight Merriman]

you will typically use $skip and $limit in the pipeline to do pagination.

you can also use skip() and limit() in a find() operation if your query doesn't require any aggregation -- either will work.

[goutham gowda]

Thanks for your reply @dwight , I have one more doubt how to get total records count for this aggregation.