MongoDB query for sorting and limiting the result

Question

I have two models User and Score

User model SCHEMA:

var UserSchema = new mongoose.Schema({
firstName: String,
lastName: String,
createdAt: Date,
scores:[
    {
        type: mongoose.Schema.Types.ObjectId,
        ref: "Score"
    }
]
});

My Score model SCHEMA:

var  ScoreSchema =  new mongoose.Schema({
score: Number,
createdAt: Date
});

So, basically I am trying to get all(limit:10) the scores in an sorted order of createdAt field and populating the score array as well.

Query I am using:

User.findOne({_id: id}).populate('scores').sort({createdAt:-1})
 .limit(10).exec(function (err, result) {
    if (err) {
        console.log(err);
        res.json({
            status: 'error',
            data: err
        })
    }
    else {
        res.json({
            status: 'ok',
            data: result
        })
    }
   })

I am still getting all the score and in the unsorted way. Please help

Try User.findOne({_id: id}).populate({ path:'scores', options: { limit: 10, sort: { createdAt: -1} } }).... — s7vr
– s7vr, Commented Jan 4, 2018 at 18:11

Ezra Chu · Accepted Answer · 2018-01-04 17:54:11Z

0

Your sort() and limit() are operating on the User model, not the scores subdocument array. If you want subdocument sorting, you may want to look at this post.

answered Jan 4, 2018 at 17:54

Ezra Chu

8224 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB query for sorting and limiting the result

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related