Breaking News: Grepper is joining You.com. Read the official announcement!

pagination in mongodb query

Add Answer

Sujal Dankhara answered on April 29, 2020 Popularity 9/10 Helpfulness 4/10

answer pagination in mongodb query

related mongo db pagination with aggregate

related pagination with aggregate in MongoDb

related pagination mongodb

related mongo paginate

pagination in mongodb query

Comment

const noOfRecordsPerPage = 10; // number of records par page
const userData = await database
    .collection("users")
    .find() // search on all data
    .sort({ _id: -1 }) // reverse the data to get latest record first
    .skip(parseInt(page) * noOfRecordsPerPage) // skip the records base on page number
    .limit(noOfRecordsPerPage) // no of record par page
    .toArray(); // turn the records into array

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: javascript mongodb-query pagination

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

Sujal Dankhara

0 Answers Avg Quality 2/10

Closely Related Answers

mongo db pagination with aggregate

Comment

db.Order.aggregate([
    {$match: {company_id: ObjectId("54c0...") } },
    {$sort: {order_number: -1 } },
    {$setWindowFields: {output: {totalCount: {$count: {}}}}}
    {$skip: 20 },
    {$limit: 10 } 
])

Popularity 10/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Oct 23 2022

Rashid P

0 Answers Avg Quality 2/10

pagination with aggregate in MongoDb

Comment

db.Order.aggregate([
    { '$match'    : { "company_id" : ObjectId("54c0...") } },
    { '$sort'     : { 'order_number' : -1 } },
    { '$facet'    : {
        metadata: [ { $count: "total" }, { $addFields: { page: NumberInt(3) } } ],
        data: [ { $skip: 20 }, { $limit: 10 } ] // add projection here wish you re-shape the docs
    } }
] )

Popularity 8/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Feb 16 2023

Jaimin Patel

0 Answers Avg Quality 2/10

pagination mongodb

Comment

    def skiplimit(page_size, page_num):
        """returns a set of documents belonging to page number `page_num`
        where size of each page is `page_size`.
        """
        # Calculate number of documents to skip
        skips = page_size * (page_num - 1)

        # Skip and limit
        cursor = db['students'].find().skip(skips).limit(page_size)

        # Return documents
        return [x for x in cursor]

Popularity 10/10 Helpfulness 3/10 Language whatever

Source: www.codementor.io

Tags: mongodb

Link to this answer
Share Copy Link

Contributed on Apr 29 2020

Odd Octopus

0 Answers Avg Quality 2/10

mongo paginate

Comment

npm install mongoose-paginate-v2

Popularity 10/10 Helpfulness 2/10 Language shell

Source: www.npmjs.com

Tags: go g

Link to this answer
Share Copy Link

Contributed on Jul 17 2021

forinda

0 Answers Avg Quality 2/10

pagination in mongodb query

Contents

More Related Answers

pagination in mongodb query

Closely Related Answers

mongo db pagination with aggregate

pagination with aggregate in MongoDb

pagination mongodb

mongo paginate

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.