MongoDB nested sort not working, need suggestion

Question

This is my Mongodb data...

I'm using this node/mongoose script to get a particular exam sorted by the score.

User.find("completedExams.exam": "test-1").sort({'completedExams.score': -1}).select({'completedExams.$': 1, name: 1}).limit(5).exec(
  function(err, allScores) {
    if (err) res.status(500).send(err);
    res.json(allScores);
  });

But I'm getting this. it's not sorting by score

sorting will not work in array field, you can to do it by aggregate(). — turivishal, Oct 17 '20 at 06:45
please follow this https://stackoverflow.com/questions/15388127/mongodb-sort-inner-array you will get the idea about it, or search for the same, Lots of questions in SO related this. — turivishal, Oct 17 '20 at 06:57

score 0 · Accepted Answer · answered Oct 17 '20 at 19:07

0

I have tried this with aggregation. This is plain mongo query. I hope you can translate it into nodejs. Here is the query :-

db.collection.aggregate([
  {
    "$unwind": "$completedExams"
  },
  {
    "$match": {
      "completedExams.exam": "test-1"
    }
  },
  {
    "$sort": {
      "completedExams.score": -1
    }
  }
])

And here is link to Mongo Playground

Hope this is what you were looking for.

answered Oct 17 '20 at 19:07

wak786

1,562
1
8
12

Thanks. This is what I really wanted :) – Kaycobad Jony Oct 18 '20 at 10:57

MongoDB nested sort not working, need suggestion

1 Answers1