#79 Pagination | Using MongoDB with Express| A Complete NODE JS Course 

you are the best teacher sir you explain it clearly with good example

Hello, from minute 06:42 you can see that page 1's first doc is the movie Divergent, and then when you switch to page 2 the same movie shows up. The same thing is happening to me. Because of this some movies are not shown in any of the pages. Any solution? Thank you in advance and congratulations for this course.

Using pagination will break the filter method as it will modify the query at the end. Thus, in Postman, we will obtain all movie lists when filtering as defined by const limit = (entered limit is empty when filtering) || 10 .

❤

Thanks

jonas copy paste !!!!!!!!!!!!!!! 🥲🥲🥲🥲

the complete code const excludeFields = ['sort', 'page', 'limit', 'fields'] const queryObj = { ...req.query } excludeFields.forEach((el) => delete queryObj[el]) //Advance Filtering (greater than/ less than/ greater than equal to/ less than equal to) let queryStr = JSON.stringify(queryObj) const regex = /\b(gte|gt|lte|lt)\b/g queryStr = queryStr.replace(regex, (match) => `$${match}`) const queryObj1 = JSON.parse(queryStr) //Sorting with one or more conditions let query = Movie.find(queryObj1) req.query.sort ? query.sort(req.query.sort.split(',').join(' ')) : query.sort('-name') //Limiting Fields req.query.fields ? query.select(req.query.fields.split(',').join(' ')) : query.select('-__v') //Pagination const page = +req.query.page || 1 const limit = +req.query.limit || 5 const skip = (page - 1) * limit query = query.skip(skip).limit(limit) if (req.query.page) { const moviesCount = await Movie.countDocuments() if (skip >= moviesCount) throw new Error(' There are no records to display!!') } const movies = await query

delete querryObj.page; delete querryObj.limit; delete querryObj.sort delete querryObj.fields console.log(querryObj); let query = Movie.find(querryObj); add this if pagination is not working