I am using mongoDb with Sails.js, finding diffucuties in sorting the records

Question

Sorting of records gives irreverent results I am using mongoDB with sails.js

Here is the syntax:

 model.find(conditions).sort({ "title": -1 })

Could you be more explicit ? What are the records ? What is the desired output and what output are you getting ? — myusuf, Oct 31 '14 at 13:57
The main issue with case sensitivity If I have records like Naresh, nar, aakash, Amit, Ball. I am getting the out put as Amit, Ball, Naresh, aakash, nar, But it should be Amit, aakash, Ball, nar, naresh — Naresh Walia, Nov 03 '14 at 05:00
You could try to use `title desc` but don't think you will get another results. — Konstantin Zolotarev, Nov 11 '14 at 21:03
Similar question http://stackoverflow.com/questions/22931177/mongo-db-sorting-with-case-insensitive — Alexey, Mar 10 '15 at 07:01

score 3 · Accepted Answer · answered Nov 12 '14 at 08:19

3

Sails supports native MongoDB queries so yo can use MongoDB Aggregation framework.

model.native(function(err, collection) {
    collection.aggregate(
        //...
    );
});

answered Nov 12 '14 at 08:19

score 0 · Answer 2 · answered Nov 11 '14 at 07:41

0

Use can use the lodash global to perform the sort instead, like this:

model.find(conditions).exec(function(err, records) {
    _.sortBy(records, function(blah){ return your_custom_logic_here; });
});

answered Nov 11 '14 at 07:41

amarprabhu

2

Don't think it's a good solution. If database will contain about a million records you will fetch all records first and then will perform sorting. It will require lot of memory and will create issues with loading time. – Konstantin Zolotarev Nov 11 '14 at 21:00
Agreed. But the default sort will not allow the OP to perform the custom action. SO scratching my head... – amarprabhu Nov 12 '14 at 08:12

2 Answers2