How can I sort and limit with Mongoose

In Mongoose, sorting and limiting query results is a common approach for optimizing data presentation and processing performance. This can be achieved by chaining the .sort() and .limit() methods on the query. Below, I will provide a detailed explanation of how to use these features, along with specific examples.

Using .sort()

The .sort() method is used to sort query results. You can specify one or more fields to sort in ascending or descending order.

Syntax:

javascript
query.sort({ field: 'asc' | 'desc' });

Example:

Suppose we have a User model. To retrieve a list of users sorted by username in ascending order, we can write:

javascript
User.find().sort({ username: 'asc' }).exec((err, users) => {
  if (err) throw err;
  console.log(users);
});

If we want to sort by creation time (createdAt) in descending order, we can write:

javascript
User.find().sort({ createdAt: 'desc' }).exec((err, users) => {
  if (err) throw err;
  console.log(users);
});

Using .limit()

The .limit() method restricts the number of query results, which is highly useful for pagination.

Syntax:

javascript
query.limit(number);

Example:

If we only want to retrieve the first 5 users, we can write:

javascript
User.find().limit(5).exec((err, users) => {
  if (err) throw err;
  console.log(users);
});

Combining .sort() and .limit()

These two methods are often used together to fulfill more complex query requirements, such as retrieving the latest 10 user records:

javascript
User.find().sort({ createdAt: 'desc' }).limit(10).exec((err, users) => {
  if (err) throw err;
  console.log(users);
});

This query first sorts by creation time in descending order, then limits the results to only the first 10. This is very useful in practical applications, such as retrieving the latest messages or articles in a social media application.

Through these methods, Mongoose provides powerful and flexible ways to handle and present database data, effectively optimizing user experience and application performance.