mongoose-find-and-paginate

A Mongoose plugin that provides a method, findAndPaginate(), for performing a find and a calculation pagination parameters at the same time.

Install

npm install mongoose-find-and-paginate --save

API

findAndPaginate

Parameters

• filter Object The filter
• options Object The Mongoose.Query options. Used for pagination:
  • options.page number The page number (optional).
  • options.perPage number The number of documents on page (optional).
  • options.skip number The number of documents to skip (optional). Used only if the page is not set.
  • options.offset number Alias for skip (optional). Used only if the page is not set.
  • options.limit number Maximum number of documents (optional). Used only if the page is not set.
• callback Function

Returns Mongoose.Query<QueryResult>

QueryResult

Type: Object

Properties

• docs Array<Mongoose.Document> The Array of documents
• totalDocs number Total number of documents that match a query
• totalPages number Total number of pages

Usage

Add plugin

import mongoose from 'mongoose';
import findAndPaginatePlugin from 'mongoose-find-and-paginate';

const schema = new mongoose.Schema({ ... });
schema.plugin(findAndPaginatePlugin);
const Model = mongoose.model('Model', schema);

Use skip(offset) & limit

const filter = { ... };
const { docs, totalDocs } = await Model.findAndPaginate(filter, {
  skip: 10,
  limit: 5,
  sort: '_id'
});

Use page & perPage

const filter = { ... };
const { docs, totalPages } = await Model.findAndPaginate(filter, {
  page: 3,
  perPage: 5,
  sort: '_id'
});

Use with Mongoose.Query methods

const filter = { ... };
const query = Model
  .findAndPaginate(filter, { page: 3, perPage: 5 })
  .populate(...)
  .select(...);

const { docs, totalPages } = await query.exec();