find() and sort() syntax

[Marcelo Barbudas]

Hi.

How does .sort() work in mongoose 1.x? The only references I could find in the tests was using .where().sort(), but where() supports only one key value pair.

Doing something like myModel.where('one', 'two').where('three', 'four').where('four', 'five').sort('something', '-1 (has to guess what -1 was)').find() seems really bad.

Tried myModel.where({one: 'two', three: 'four'}).sort().find() and it happily ignored the conditions.

The mongoosejs.com docs are really confusing, they barely touch query syntax.

-M.

[mkoistinen]

Hi Marcelo,

I'm pretty new too, but let me help where I can.

You can sort in straight find() queries too, like this:

Users.find({ some-criteria }, { lastname: 1, firstname: 1, password: 0 }, function(err, users) {... }).

This will return the collection from Users that matches your criteria in the order lastname (ascending), then firstname (ascending) and it will omit the password field from the results.  Perhaps this would be more intuitive then using where() for you?

[Marcelo Barbudas]

Hi Martin,

Thanks for taking the time to answer.

myModel.find(conditions, [], { sort: ['updated_at', 1], limit: 3 };

limit works, sort doesn't. I'm trying to sort DESC.

-

M.

[Marcelo Barbudas]

Doesn't work with -1 in sort either.

[mkoistinen]

Assuming 'updated_at' is a field in your document.

Have you tried:

myModel.find(conditions, [], { updated_at: -1, limit: 3 }, function());

?

[mkoistinen]

Actually, its not working for me either....

[Marcelo Barbudas]

Anyone? Still haven't figured it out.

-m.

[Zoltan Kalmar]

Syntax of sorting:

Users.find({ some-criteria }, array_of_field_names)
.sort('sort_field_name', -1) // DESC order
.execFind( function(err, users) {... }); // since mongoose 1.0.14

On Sun, Feb 20, 2011 at 3:24 PM, Marcelo Barbudas <nos...@gmail.com> wrote:
> Anyone? Still haven't figured it out.
> -m.

--
kalmi

[mkoistinen]

Works perfectly for me, thanks Kalmi!

[Marcelo Barbudas]

Thanks for the help kalmi.

[easternbloc]

Huzzah, thanks for this. Is the API on the website now out of date
then?

[Shunsuke Watanabe]

Hi, all.

Kalmi's example doesn't work for me.
I'm using Mongoose 1.0.16 on node 0.2.6

This works fine.

User.find({/* conditions */},[/* fields */],{sort:[['date',-1]], limit:
10},function(err,docs){
});

But I don't like this syntax.
It's obtrusive to read and write.

The old way is better, isn't it?

User.find({}, function(err, docs){}).sort('date',-1).limit(10);

I begin to think of abandoning to use Mongoose...

[Guillermo Rauch]

User.find({}, ['field']).sort([['date'], -1).limit(10).run(function(err, docs){

}).

--
Guillermo Rauch
http://devthought.com

[Shunsuke Watanabe]

Hi, Mr.Rauch.

Thanks for your example.

I tried run() method and got this:
TypeError: Object #<a Query> has no method 'run'

[easternbloc]

Ditto, only works with execFind.

[Shunsuke Watanabe]

Yeah, I could make Kalmi's example worked.
I mistakenly passed array to sort method.

[michael.grant]

this should work:

find({}, [], { sort: [['stamp', -1]], limit: 10 }, function( error, ecollection){

});

[Sajith Kumar Arimbra]

this works for me

Category.find({parentuid:catid}, null, {sort:{name:1}, skip:0, limit:20}, function(err, categories) {  

 callback(err, categories);

 });