Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

mongoose request order by

mongoose request order by


I have a problem with a mongo request:

    function(err, result){

I have

{ [MongoError: Error: Unsupported projection option: date_register] name: 'MongoError' }

as error

I'd like to get my users by date_register DESC


Problem courtesy of: Ajouve


This will vary slightly depending on your version of Mongoose, but the method signature for findOne looks something like this:

function findOne (conditions, fields, options, callback)

What you intend as options (the sort), mongoose is handling as fields (which fields to load).

You might try explicitly passing null for fields:

models.user.findOne({}, null, {sort: {date_register: -1 }}, callback);

But if you can, you should probably use the query API, which is clearer, like:

models.user.findOne({}).sort({date_register: -1}).exec(callback);
Solution courtesy of: numbers1311407


View additional discussion.

This post first appeared on Node.js Recipes, please read the originial post: here

Share the post

mongoose request order by


Subscribe to Node.js Recipes

Get updates delivered right to your inbox!

Thank you for your subscription