Node.js: Query Aggregation not working (mongodb)

Question

So I'm kinda new to node.js. And I can't understand why Aggregate queries don't work for me. I've tried the same query at the Mongo Shell and it worked perfectly. Here's the code:

db.collection("companies").aggregate({$match:
{$or:
    [{ $and:
        [{ left: {$gt: 2}}, {left: {$lt: 11}}]},
    { $and:
        [{ right: {$gt: 2}}, {right: {$lt: 11}}]}]}},
{ $group:
    {_id:null, 
        Sum:{$sum: "$earn"}}}, 

function(err, data){

    if (err) throw err;

    console.log(data[0]);
    console.log(data.value);
    console.log(data.Sum);
});

Console output:

undefined
undefined
undefined

Hannah May · Accepted Answer · 2017-09-23 15:03:40Z

1

Aggregation argument needs to be an array, because aggregation works on pipeline concept where output of last pipeline will become input for current pipeline.

db.collection("companies").aggregate([
{$match:
  {$or:
      [{ $and:
          [{ left: {$gt: 2}}, {left: {$lt: 11}}]},
      { $and:
          [{ right: {$gt: 2}}, {right: {$lt: 11}}]}]
}},
{ $group:
    {_id:null, 
        Sum:{$sum: "$earn"}}}], 

function(err, data){

    if (err) throw err;

    console.log(data[0]);
    console.log(data.value);
    console.log(data.Sum);
});

edited Sep 23, 2017 at 15:03

Hannah May

4044 silver badges12 bronze badges

answered Sep 23, 2017 at 14:50

Pankaj Jatav

2,1782 gold badges16 silver badges22 bronze badges

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

1 Comment

Danny Lipp Over a year ago

Thanks for helping!

Collectives™ on Stack Overflow

Node.js: Query Aggregation not working (mongodb)

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