I am interested in retrieving the documents from a mongoose collection in reverse order

Question

I am interested in retrieving the documents from a mongoose collection in reverse order

I am trying to retrieve the most recent document from a collection using mongoose in conjunction with nodejs/expressjs.

In addition, I am implementing server-side pagination which prohibits me from reversing the order of retrieval after fetching.

exports.getProjects = (req, res, next) => {


const page = +req.query.page || 1; 
let totalItems;
Project
    .find()
    .countDocuments()
    .then(numProducts => {
        totalItems = numProducts;
        return Project.find()
            .skip((page - 1) * ITEMS_PER_PAGE)
            .limit(ITEMS_PER_PAGE)
    })
    .then(result => {
        return res.status(200).json({
            projects: result,
            currentPage: page,
            itemCount: totalItems,
            itemsPerPage: ITEMS_PER_PAGE,
        });
    })
    .catch(err => {
        console.log(err);
    })

};

node.js mongodb express mongoose

Answer 1

Answer №1

To incorporate sorting into your query, make sure to specify the attribute that you want to sort by, such as date or a numerical value. You can utilize aggregation in the following manner:

const projectsCursor = await Project.aggregate([
{$match: Query},
{$sort: {field: 1}},
{$skip: number},
{$limit: someNumber}
])

Answer 2

To incorporate sorting into your query, make sure to specify the attribute that you want to sort by, such as date or a numerical value. You can utilize aggregation in the following manner:

const projectsCursor = await Project.aggregate([
{$match: Query},
{$sort: {field: 1}},
{$skip: number},
{$limit: someNumber}
])

Answer 3

Answer №2

Are you in search of the sort() function within mongoose? You can easily organize your collection using a variety of techniques.

Project.find({}).sort('test').exec(function(err, docs) { ... });
Project.find({}).sort([['date', -1]]).exec(function(err, docs) { ... });
Project.find({}).sort({test: 1}).exec(function(err, docs) { ... });
Project.find({}, null, {sort: {date: 1}}, function(err, docs) { ... });

Choose one of these methods based on your specific needs and use the following code for smooth pagination.

app.get('/projects', async (req, res) => {
  // destructure page and limit and set default values
  const { page = 1, limit = 10 } = req.query;

  try {
    // execute query with specified page and limit
    const projects = await Project.find()
      .sort({ field : criteria})
      .limit(limit * 1)
      .skip((page - 1) * limit)
      .exec();

    // obtain total number of documents in the Project collection 
    const count = await Project.countDocuments();

    // send response with projects, total pages, and current page information
    res.json({
      projects,
      totalPages: Math.ceil(count / limit),
      currentPage: page
    });
  } catch (err) {
    console.error(err.message);
  }
});

Note: The criteria parameter can be any of the following: "asc", "desc", "ascending", "descending", 1, or -1

Answer 4

Are you in search of the sort() function within mongoose? You can easily organize your collection using a variety of techniques.

Project.find({}).sort('test').exec(function(err, docs) { ... });
Project.find({}).sort([['date', -1]]).exec(function(err, docs) { ... });
Project.find({}).sort({test: 1}).exec(function(err, docs) { ... });
Project.find({}, null, {sort: {date: 1}}, function(err, docs) { ... });

Choose one of these methods based on your specific needs and use the following code for smooth pagination.

app.get('/projects', async (req, res) => {
  // destructure page and limit and set default values
  const { page = 1, limit = 10 } = req.query;

  try {
    // execute query with specified page and limit
    const projects = await Project.find()
      .sort({ field : criteria})
      .limit(limit * 1)
      .skip((page - 1) * limit)
      .exec();

    // obtain total number of documents in the Project collection 
    const count = await Project.countDocuments();

    // send response with projects, total pages, and current page information
    res.json({
      projects,
      totalPages: Math.ceil(count / limit),
      currentPage: page
    });
  } catch (err) {
    console.error(err.message);
  }
});

Note: The criteria parameter can be any of the following: "asc", "desc", "ascending", "descending", 1, or -1

I am interested in retrieving the documents from a mongoose collection in reverse order

Answer №1

Answer №2

Similar questions

Tips for linking a Google Meet invitation to a Calendar Event (generated using a Service Account)

The POST method in Node JS request-promises does not properly handle string inputs

The recently launched AWS Amplify application (serverless) is encountering a 403 Access Denied error

What is the process of incorporating a lowercase normalizer into an Elasticsearch mapping object?

Error! The function worker.recognize(...).progress is throwing an error. Any ideas on how to resolve this

Unable to establish headers once they have been issued - routing error

Struggling to launch the Node.js server on the OpenShift platform

Installing and running Node.js within a tomcat server

Node.js: Capturing requests and responses for console logging

Express - Accessing 'Database' before initialization is not possible

Using Node.js to retrieve table data from a URL

Tips for simulating next/router in vitest for unit testing?

Issues are arising with the functionality of React-native link

What is the best way to encode and split audio files so that there are no gaps or audio pops between segments when I put them back together?

Tips for reducing file size of an image post-upload using Sharp JS and Multer

How does the use of nodejs, a server-side scripting language, tie into ReactJs or other front-end languages?

Can Socket.io be connected only when a user logs in?

Strip the URL prefixes to access files in the public directory easily

Is there a caching mechanism for packages in npm?

Save the result of a terminal command into an sqlite database