Node.js "ignore" $sort in a collection.aggregate query

Question

This could be a dumb question, but I'm desperate already! I need to do this query:

db.clients.aggregate(
{
  $group: {
      _id: '$enterprise',
      lodging_days: { $sum: '$lodging_days' }
  }
},
{
  $sort : {
    lodging_days: -1
  }
})

And, if I copy this on the mongo bash, I returned this: Bash Return (Sorry, I can't upload images yet)
JUST LIKE I WANT!

But, when I put the query on node:

router.get('/query', function(req, res){
  var db = req.db;
  var clients=db.get('clients');

  clients.aggregate(
    {
      $group: {
        _id: '$enterprise',
        lodging_days: { $sum: '$lodging_days' }
      }
    },
    {
      $sort: {
        'lodging_days': -1
      }
    },
    function(e, data){
      res.json(data);
    }
  );
});

This "ignore" the $sort and return me this: Interface Return
Now, my question are... Why!? And what can I make to fix it?

Try to wrap your pipeline into array. db.collection.aggregate( [ { <stage> }, ... ] ) — Vladislav Kievski
– Vladislav Kievski, Commented Jul 21, 2016 at 14:56
The way you call aggregate does not soom to match how the API says you should be calling it. mongodb.github.io/node-mongodb-native/2.2/api/… — Mike 'Pomax' Kamermans
– Mike 'Pomax' Kamermans, Commented Jul 21, 2016 at 14:58
From your link: // Execute aggregate, notice the pipeline is expressed as an Array collection.aggregate([]) I mean you need to do next clients.aggregate([your code with group, sort and function]); — Vladislav Kievski
– Vladislav Kievski, Commented Jul 21, 2016 at 15:00
@VladislavKievski Oh!! That's the way! It's work! Thanks! Plz Post this like an answer, so I can validate it. — Fernando Gonzalez
– Fernando Gonzalez, Commented Jul 21, 2016 at 15:03

Vladislav Kievski · Accepted Answer · 2016-07-22 06:49:27Z

1

Your need to wrap your pipeline into array.

router.get('/query', function(req, res){
  var db = req.db;
  var clients=db.get('clients');

  clients.aggregate([
    {
      $group: {
        _id: '$enterprise',
        lodging_days: { $sum: '$lodging_days' }
      }
    },
    {
      $sort: {
        'lodging_days': -1
      }
    }],
    function(e, data){
      res.json(data);
    }
  );
});

edited Jul 22, 2016 at 6:49

answered Jul 21, 2016 at 15:06

Vladislav Kievski

1,65711 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fernando Gonzalez Over a year ago

Thanks. It need to wrap only the aggregate commands, the function goes outside. router.get('/query', function(req, res){ var db = req.db; var clients=db.get('clients'); clients.aggregate([ { $group: { _id: '$enterprise', lodging_days: { $sum: '$lodging_days' } } }, { $sort: { 'lodging_days': -1 } }], function(e, data){ res.json(data); } ); });

Collectives™ on Stack Overflow

Node.js "ignore" $sort in a collection.aggregate query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related