Mongoose: mongodb sort not working in nodejs

Created on 2 Oct 2016 · 2Comments · Source: Automattic/mongoose

SORT function not working properly in the nodejs with mongoose buts works perfectly in mongo shell .

Mongo DB + NodeJS Project:
dependencies
"body-parser": "^1.15.2",
"express": "^4.14.0",
"mongoose": "^4.6.2"

Error: sort() only takes 1 Argument

mongoose.connect('mongodb://localhost:27017/testDB');
var Schema = mongoose.Schema;
var noSchema = new Schema({}, { strict: false });
var data = mongoose.model('tables', noSchema);

data.find().sort({"id": 1}, function(err,docs){
res.json(docs);
})

Source

iiitmahesh

Most helpful comment

Try moving your callback to .exec:

data.find().sort({"id": 1}).exec(function(err,docs){
  if (err) throw err;
  res.json(docs);
})

Many of the query operators don't accept a final callback and require using exec.

zbjornson on 6 Oct 2016

❤4 👍4

All 2 comments

Try moving your callback to .exec:

data.find().sort({"id": 1}).exec(function(err,docs){
  if (err) throw err;
  res.json(docs);
})

Many of the query operators don't accept a final callback and require using exec.

zbjornson on 6 Oct 2016

❤4 👍4

I'm having a similar issue with the 'sort' option using MongoDB with Express.
I can sort in the Mongo shell but when I use the sort in an Express function
it affects the JSON results by adding something that is non parsible. I guess
the reality is that its probably easier to apply sorting somewhere else. Perhaps
against the JSON object. MongoDB disappoints again.

I used the approach above but got the same parsing error. I just can't understand
why the sort would alter the structure of the JSON result other than to reorder the
entries.