Comments (2)
Edit December 4 2020:
Here is a blog post that I wrote with detailed information about it
Pagination in nodejs with mongo
Hello!
Start by accepting (and sending) these new query parameters on your API skip
and limit
limit
is the page size you want, and skip
is to get the page you want.
For example, you want 20 elements per page, you have to call the API like this:
First Page
axios.get(`myapi.com/api/users?limit=20&skip=0`
Second page
axios.get(`myapi.com/api/users?limit=20&skip=20`)
Just send on skip the current page number minus 1 times page size
axios.get(`myapi.com/api/users?limit=${PageSize}&skip=${ (CurrentPage-1) * PageSize }`)
Now, back on the server side
route.get('/api/users', (req, res)=> {
const limit = parseInt(req.query.limit);
const skip = parseInt(req.query.skip);
MyMongooseModel.find({ }).skip(skip).limit(limit).exec()
})
from bulletproof-nodejs.
i have made a helper function for pagination and search filter with sorting ....
const listData = async (doc, filter) => {
let { page = 0, limit = 10, sort = 1, sortby = `createdAt`, where = {} } = filter
const BOOLENTYPE = ['isDeleted']
/*search filters */
let search = {}
for (const cloumn in where) {
if (where.hasOwnProperty(cloumn) && where[cloumn]) {
if (BOOLENTYPE.includes(cloumn) && typeof where[cloumn] === Boolean)
search[cloumn] = where[cloumn];
else
search[cloumn] = { '$regex': where[cloumn], '$options': 'i' }
}
}
/*code for pagination start */
limit = parseInt(limit)
page = parseInt(page)
page = limit * (page - 1)
page = page < 1 ? 0 : page//negative values can break skip
let data = []
try {
data = await doc.find(search) // find all users with filter
.skip(page) // skip the first n items
.limit(limit) // limit to n items
.sort({ [sortby]: sort }) // sort asc/dsc by createdAt
let totalCount = await doc.countDocuments(search)
let totalPages = Math.ceil(totalCount / limit)
return {
data: data,
pages: totalPages,
totalCount,
success: true,
errors: [],
message: ""
};
} catch (error) {
// console.log(error)
return {
success: false,
message: error.toString(),
description: `error while fetching data please check data and data type`
}
}
}
module.exports = { listData }
from bulletproof-nodejs.
Related Issues (20)
- How to implement the swagger following this structure? HOT 2
- Email client replacement HOT 1
- Implementation with Mysql/pgsql with typescript HOT 3
- examples for creating new models in mongo HOT 1
- Project structure by feature HOT 2
- add absolute imports? HOT 1
- Where do you add utility functions and constants? HOT 1
- Absolute import "Cannot find module @/*" HOT 5
- Jwt invalid algorithm HOT 2
- Recreate code to be compatible with all os development environment
- Changing a request would require changes in 3 places of the code, is there a better solution? HOT 1
- api status handling
- Better testing project structure/ configuration? HOT 1
- Using a different database for tests HOT 1
- Where store Push Notification Token?
- Refactoring Sub/Pub Layer Poll HOT 1
- Is there same or similar example in js? HOT 1
- Redis client HOT 2
- adapt for mySQL HOT 2
- Update Mongoose for Heroku Deployment
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bulletproof-nodejs.