How can I sort and limit with Mongoose

Question

I made an review app with Express and Mongoose. I have an review model like below:

var mongoose = require('mongoose');

var ReviewSchema = mongoose.Schema({
    title: String,
    description: String,
    rating: Number
}, {
    timestamps: true
}
);

module.exports = mongoose.model('Review', ReviewSchema);

In my controller I just get all reviews list as below. But now I want to get a list with 10 recently reviews & sort by (orderby timestamps). How can I do it with mongoose? Please help me! I am a newbie with NodeJS and Mongodb.

exports.findAll = function(req, res) {
    console.log("Fetching Review...")
    // Retrieve and return all reviews from the database.
     Review.find(function(err, reviews){
        if(err) {
            console.log(err);
            res.status(500).send({message: "Some error occurred while retrieving Review."});
        } else {
            res.send(reviews);
        }
    });
};

Thanks you so much

Bottommost

Try this Review.find({}).sort({ createdAt: 1 }).limit(10) – Kowtow

It's not work, Anthony Winzlet – Bottommost

Answer 1

This should work for you:

Review.find()
  .sort({_id: -1})
  .limit(10)
  .then(reviews => {
    console.log(reviews)
  });

Rudder

Awesome. Thanks. You should mark the answer so hopefully it could help others. – Rudder

Answer 2

you can try like this :

Review.find({}, function(err,reviews){}).sort({_id: -1}).limit(10);

Mythopoeia

Answer 3

  //note that the req param is not used so I set it to _
module.exports.findAll = async(_,res) => {
   try{
     const someReviews = await Reviews.find({});
     console.log(someReviews);
     .sort({"createdAt": -1})//-1 from newest to oldest 1 otherwise
     .limit(10);
     res.status(200).send(someReviews);
   }catch(e){
      console.log({error: e});
      res.status(500).send({error: `Could not fetch reviews`};
   }
}

Southworth