CODEWITHSUNDEEP
node.jsmongodbexpressmongoose
Erik
Erik

Reputation: 14778

How to make pagination with mongoose

I want to make a pagination feature in my Collection. How can find a documents with 'start' and 'limit' positions and get total document number in a single query?

Upvotes: 12

Views: 21958

Answers (6)

Najmus Sakib
Najmus Sakib

Reputation: 526

I am using this function,

You can check if prev and next data is available or not.

async (req, res) => {
let { page = 1, size = 10 } = req.query
page = parseInt(page)
size = parseInt(size)
const query = {}
const totalData = await Model.find().estimatedDocumentCount()
const data = await Model.find(query).skip((page - 1) * size).limit(size).exec()


const pageNumber = Math.ceil(totalData / size)
const results = {
    currentPage: page,
    prevPage: page <= 1 ? null : page - 1,
    nextPage: page >= pageNumber ? null : page + 1,
    data
}
res.json(results) }

To know more estimatedDocumentCount

Upvotes: 0

RBJT
RBJT

Reputation: 1

   user.find({_id:{$nin:friends_id},_id:{$ne:userId}},function(err,user_details){
    if (err)
    res.send(err);
    response ={
        statusCode:200,
        status:true,
        values:user_details
    }
    res.json(response);
   }).skip(10).limit(1);

Upvotes: 0

Yosvel Quintero
Yosvel Quintero

Reputation: 19090

You can use the plugin Mongoose Paginate:

$ npm install mongoose-paginate

After in your routes or controller, just add :

Model.paginate({}, { page: 3, limit: 10 }, function(err, result) {
    // result.docs 
    // result.total 
    // result.limit - 10 
    // result.page - 3 
    // result.pages 
});

Upvotes: 10

JohnnyHK
JohnnyHK

Reputation: 312115

You can't get both results in one query; the best you can do is to get them both using one Mongoose Query object:

var query = MyModel.find({});
query.count(function(err, count) {...});
query.skip(5).limit(10).exec('find', function(err, items) {...});

Use a flow control framework like async to cleanly execute them in parallel if needed.

Upvotes: 19

Hitesh Joshi
Hitesh Joshi

Reputation: 724

UPDATE :

Using skip and limit is not good for pagination. Here is the discussion over it.

@Wes Freeman, Gave a good answer. I read the linked pose, you should use range query. n = 0; i = n+10; db.students.find({ "id" : { $gt: n, $lt: (n+i)} } );

OLD ANSWER (don't use this)

use something like

n = db.students.find().skip(n).limit(10);
//pass n dynamically, so for page 1 it should be 0 , page 2 it should be 10 etc

more documentation at http://www.mongodb.org/display/DOCS/Advanced+Queries

Upvotes: 1

Eve Freeman
Eve Freeman

Reputation: 33175

If you plan to have a lot of pages, you should not use skip/limit, but rather calculate ranges.

See Scott's answer for a similar question: MongoDB - paging

Upvotes: 4

Related Questions