我该如何对猫鼬进行排序和限制 [英] How can I sort and limit with Mongoose

问题描述

我使用Express和Mongoose开发了一个评论应用程序.我有一个如下的评论模型:

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);

在我的控制器中，我仅获得以下所有评论列表.但现在我想获得一份包含10条近期评论的列表&排序依据(按时间戳排序).我怎么用猫鼬呢?请帮我！我是NodeJS和Mongodb的新手.

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);
        }
    });
};

非常感谢您

推荐答案

这应该对您有用:

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

这篇关于我该如何对猫鼬进行排序和限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！