mongoose pagination

Question

I'm trying to make an easy pagination for a REST service with MongoDB and Mongoose. Here's how I'm doin it right now.

As you can see I'm sending 0 on 'next' variable, but I just want to send zero when there are no more results. How could I get when results are over and there are no more to get?

   var user = User.find(
    {},
    {},
    {skip: skip, limit: limit},
    function(err, docs) {
        if (!err) {
            res.json({users: docs, next: 0} );
        } else {
            throw err;
        }
    });

Thanks!

PS: I'm using node.js and express.

score 0 · Answer 1 · answered Sep 28 '12 at 19:02

0

Try this:

if ( !docs ) {
  res.json({users: [], next: 0});
}

answered Sep 28 '12 at 19:02

chovy

59,357
43
187
234

score 0 · Answer 2 · answered Sep 28 '12 at 19:24

if i got your question right you would like to send the ammount of remaining documents for the next query, if so you could query with limit * 2 but only return 'limit' documents, substract limit from docs.length and you will get the ammount of remaining documents for the next query.

there may be a better solution with a more adanvced query.

mongoose pagination

2 Answers2