Mongoose Query - Sort by Name field type

[James Lukensow]

Is it possible to sort a query by the Name Type field?

The field is named: name

I tried the following:

.sort('name')

.sort('name.first')

Anyone have any ideas?

[Vito Belgiorno-Zegna]

Hey James,

The Mongoose API docs cover queries, including .sort here: 

http://mongoosejs.com/docs/api.html#query_Query-sort

This is the kind of syntax you want to follow:

model.find().sort({ name: 'criteria' }).exec(function(err, model) { ... });

'criteria'

can be:

asc, desc, ascending, descending, 1, or -1

Hope that helps.

[Jed Watson]

Hey Vito and James,

The shorthand syntax should work too, as a simplification you can .sort('path') and .sort('-path') for desc

With the name field there is absolutely no reason it wouldn't sort like any other field in MongoDB.

Although you would need to sort by the full path 'name.first' or 'name.last' - sorting on just 'name' will have no effect.

Without seeing your schema unfortunately it's hard to help more specifically, I recommend experimenting with the mongo shell or RoboMongo to visualise your queries if you're having trouble figuring out what's going on.

Hope that helps!

- Jed.

[James Lukensow]

Oh jeeze, I can't believe I didn't try q.sort('name.last'). Thanks all!

[Ryan Cole]

Hey James there's a mongo course running now by mongo university. Covers all this stuff. :) I'm in it now too!