Can mongoose-paginate-v2 be used to easily navigate through populated documents?

Question

Can mongoose-paginate-v2 be used to easily navigate through populated documents?

My User and Post models are set up, with User.favPosts being an array of references to the Post model. When I call paginate like this:

options = { populate: {path: 'favPosts'} };
const result = await User.paginate({}, options)

The resulting user document is now populated with posts:

{
  "docs": [
    {
      "_id": "6299ffa5c2ca4cdeebd1f513",
      "name": "user",
      "email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="4b2e262a22270b262a222765282426">[email protected]</a>",
      "favPosts": [
        {
          "_id": "629b299897f46f31761ad7a7",
          "title": "Available Test 5",
          "description": "Lorem ipsum dolor sit"
        },
        {
          "_id": "629b1edf108e765744d2560d",
          "title": "Available Test 4",
          "description": "Lorem ipsum dolor sit"
        },
        {
          "_id": "629b1c0027bf0eb197c057dd",
          "title": "Available Test 4",
          "description": "Lorem ipsum dolor sit"
        }
      ]
    }
  ],
  "totalDocs": 1,
  "offset": 0,
  "limit": 10,
  "totalPages": 1,
  "page": 1,
  "pagingCounter": 1,
  "hasPrevPage": false,
  "hasNextPage": false,
  "prevPage": null,
  "nextPage": null
}

I am currently able to paginate users, but I want to be able to paginate the populated documents (posts) as well, including getting the total count, page numbering, etc. The desired result should look like this:

{
  "docs": [
    {
      "_id": "629b299897f46f31761ad7a7",
      "title": "Available Test 5",
      "description": "Lorem ipsum dolor sit"
    },
    {
      "_id": "629b1edf108e765744d2560d",
      "title": "Available Test 4",
      "description": "Lorem ipsum dolor sit"
    },
    {
      "_id": "629b1c0027bf0eb197c057dd",
      "title": "Available Test 4",
      "description": "Lorem ipsum dolor sit"
    }
  ],
  "totalDocs": 3,
  "offset": 0,
  "limit": 10,
  "totalPages": 1,
  "page": 1,
  "pagingCounter": 1,
  "hasPrevPage": false,
  "hasNextPage": false,
  "prevPage": null,
  "nextPage": null
}

Is it possible to achieve this using mongoose-paginate-v2?

javascript mongodb mongoose pagination

Answer 1

Answer №1

After some exploration, I discovered a different approach to the problem. Instead of utilizing mongoose-paginate-v2, I turned to the mongoose-aggregate-paginate-v2 module:

const aggregate = User.aggregate([ // This is a Promise without using "await"
    { $match: { userId } }, // Filtering for users in the collection
    {
// Adding posts:
        $lookup: {
            from: 'posts',
            localField: 'favPosts',
            foreignField: '_id',
            as: 'documents',
            pipeline, // Applying post filters here
        },
    },
// Using unwind + replaceRoot to move posts to the root level, creating an array of posts instead of users
    {
        $unwind: '$documents',
    },
    {
        $replaceRoot: { newRoot: '$documents' },
    },
]);

Next step was passing this Promise to the paginator:

const options = { page: 2, limit: 10 };
const result = await User.aggregatePaginate(aggregate, options);

Answer 2

After some exploration, I discovered a different approach to the problem. Instead of utilizing mongoose-paginate-v2, I turned to the mongoose-aggregate-paginate-v2 module:

const aggregate = User.aggregate([ // This is a Promise without using "await"
    { $match: { userId } }, // Filtering for users in the collection
    {
// Adding posts:
        $lookup: {
            from: 'posts',
            localField: 'favPosts',
            foreignField: '_id',
            as: 'documents',
            pipeline, // Applying post filters here
        },
    },
// Using unwind + replaceRoot to move posts to the root level, creating an array of posts instead of users
    {
        $unwind: '$documents',
    },
    {
        $replaceRoot: { newRoot: '$documents' },
    },
]);

Next step was passing this Promise to the paginator:

const options = { page: 2, limit: 10 };
const result = await User.aggregatePaginate(aggregate, options);

Can mongoose-paginate-v2 be used to easily navigate through populated documents?

Answer №1

Similar questions

Circle a component around another on the vertical axis (z-index)

When hovering over the background, it will enlarge but the text in front will remain the same size

Creating a dynamic user interface in Angular 6 that successfully tracks changes without reliance on the parent

Fresh ajax requests are not clearing the current data displayed in the JSP table

Extract information from a JSON Object using a specific pathway

Showing XML content with JavaScript

What are the methods for altering the material of a glTF model using THREE.js?

The art of breaking down a content list into pages using JavaScript or jQuery

Is it necessary for me to retrieve any crucial information from the switch cases, or is simply having them set up in this way sufficient to distinguish between various PHP

The error remains a mystery to the console - could it be possibly linked to the onclick() method?

Trapped in the Web of Facebook OAuth

Encountering an issue with importing createSagaMiddleware from 'redux-saga' while working on my create-react-app project

Navigating Through Grid and Card Content in React

Building complex queries with the MongoDB C# driver using the native API

Trigger the input with a delay function, pause if the input value is modified

What steps should I take to include a Follow - Unfollow Button on my Website?

Karma jasmine and an angular controller that utilizes the 'Controller as' syntax (where 'this' is used instead of $scope)

What are some methods for creating a Venn Diagram that includes data within each section using SVG, CSS, or Canvas?

Trouble with Javascript file functioning correctly

If a checkbox is checked, then the value in the textbox should be multiplied by 0