Using Sails.js is it possible to sort with waterline by true/false?

Question

I'm using Sails.js and thus, Waterline and I'm wondering if the following is possible?

teamFind: function(req,res,next){
 User.find().skip(req.param('listPage')).limit(26).sort('school').sort('officialUser').exec(function(err,users){
      res.view({
        teams:users,
        nextPage: parseInt(req.param('listPage'),10)+26
      });
    });
  },

What I'm wanting to do is return the users sorted by school and then move the "Official Users" to the top of that list. Currently this just returns everything in alphabetic order. Is the issue that 'officialUser' is a boolean?

I guess in the end the boolean values translate to zeros and ones.. Hence the ones with the false should come first.. Is it the case..?? — Mahammad Adil Azeem, Jul 21 '14 at 06:58
You know, it never crossed my mind that it would work that way (false FIRST because it's 0). I'll give that a try. — gregdillon, Jul 21 '14 at 20:17
The key was switching the sorts around ('school' last) and changing 'officialUser' to 'officialUser desc'. — gregdillon, Jul 22 '14 at 00:43
I'm sorry, that was unclear. I should have said move sort('school') after sort('officialUser desc'). — gregdillon, Jul 22 '14 at 00:57
@gregdillon, glad you figure this out--please post it as an answer (you can post and accept answers to your own question) so that others can find it. — sgress454, Aug 02 '14 at 23:17

score 0 · Answer 1 · answered Aug 04 '14 at 00:45

0

Solved! The main issue was that I had objects I wanted to sort in the wrong order. Also, I needed to add 'desc' to the 'officialUser' sort.

answered Aug 04 '14 at 00:45

gregdillon

23
4

Using Sails.js is it possible to sort with waterline by true/false?

1 Answers1