Mongodb Nodejs driver aggregate query does not return data

Question

I've Mongodb aggreage query which works fine in the RoboMongo shell and yeild me the correct results.

Robo Mongo Shell Query

db.getCollection('application-filters').aggregate(
{

      $match: { 


          "StatusName" : {$in:["Rejected","Expired"]}


}},
{
$group:{
    _id: "$StatusName", COUNT : { "$sum":1} 
}},
{
$project: {
    StatusName:1,
    Count : "$COUNT"
}
},
{
    $sort:{
        Count:-1
    }
}
)

I've copied and paste the same query and trying to execute with nodejs mongodb 2.2 driver. it gives me no result

Here is JavaScript code

module.exports = mPool => {
  return {
    getcountbyStatus (countstatusfilterParams) {
      console.log(countstatusfilterParams)
      return mPool.collection('application-filters').aggregate(
        {

          $match: {

            'StatusName': {$in: ['Rejected', 'Expired']}

          }},
        {
          $group: {
            _id: '$StatusName', COUNT: {'$sum': 1}
          }},
        {
          $project: {
            StatusName: 1,
            Count: '$COUNT'
          }
        },
        {
          $sort: {
            Count: -1
          }
        }
).toArray(function (err, data) {
  if (!err) {
    console.log(data)
  }
})
    }
  }
}

Any help will be highly appreciated.

Thanks

did you solve the problem? I'm facing the same problem

Dor Lugasi-Gal
– Dor Lugasi-Gal

2019-05-29 12:45:17 +00:00
Commented May 29, 2019 at 12:45 — Dor Lugasi-Gal
– Dor Lugasi-Gal, Commented May 29, 2019 at 12:45

Burdy · Accepted Answer · 2017-08-01 12:47:12Z

2

Have you tried this:

db.collection.aggregate([
      // do your query
]).toArray(function(err, docs) {
      // do something
}

So in this case your Mongodb aggreage should be:

module.exports = mPool => {
  return {
    getcountbyStatus (countstatusfilterParams) {
      console.log(countstatusfilterParams)
      return mPool.collection('application-filters').aggregate([
        {

          $match: {

            'StatusName': {$in: ['Rejected', 'Expired']}

          }},
        {
          $group: {
            _id: '$StatusName', COUNT: {$sum: 1}
          }},
        {
          $project: {
            StatusName: 1,
            Count: '$COUNT'
          }
        },
        {
          $sort: {
            Count: -1
          }
        }
]).toArray(function (err, data) {
  if (!err) {
    console.log(data)
  }
})
    }
  }
}

answered Aug 1, 2017 at 12:47

Burdy

6114 silver badges11 bronze badges

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

2 Comments

MAQ Over a year ago

No it still doesn't work. I'm still getting blank array.

MAQ Over a year ago

I even tried to replicate the code based on this example mongodb.github.io/node-mongodb-native/2.2/tutorials/aggregation But still doesn't works

Collectives™ on Stack Overflow

Mongodb Nodejs driver aggregate query does not return data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related