Sorting in Loopback Connector Mongo

Question

I'm having a real issue. I'm trying to do a query, limit, sort, etc. This is what I'm doing:

MyModel.find( { where: { "location": 
                       { "near": { "lat": "80", "lng": 80 }}
              },
              {  limit: 50, offset: 0, skip: 10,
                 sort: { "name": "asc" }
              }, 
              function(err, docs) {
                  var retval    = docs || [];
                  return cb(null, retval);
           });

What is the magic sauce to do limit, skip, and sort?

Any help is appreciated. Thanks

score 1 · Answer 1 · answered Aug 19 '15 at 17:41

1

Try using the order property as shown in the documentation here:

https://docs.strongloop.com/display/public/LB/Order+filter

example.find({
 order: 'price DESC',
 limit: 3 });

answered Aug 19 '15 at 17:41

JSimonsen

2,642
1
13
13

score 0 · Accepted Answer · answered Aug 20 '15 at 14:23

MyModel.find( { where: { "location": { "near": { "lat": "80", "lng": 80 }}},
            limit: 50,
            offset: 0, 
            skip: 10, 
            order: "name ASC"
          }, 
          function(err, docs) {
              var retval    = docs || [];
              cb(null, retval);
       });

I think this is the way it should look. try reading this and documentation under it: https://docs.strongloop.com/display/public/LB/Querying+data

Sorting in Loopback Connector Mongo

2 Answers2