Can I apply forEach in aggregate query in MongoDB?

[Shaishab Roy]

I have a member collection and find members by specific conditions and after get members I need to do some calculation for each member. To calculate need query on the same collection.

My process is

    var members = db.collection('member').find({ createdDate: currentDate, country: 'BD'}).toArray();

    members.forEach(function(doc) {

      var result = db.collection('member').aggregate([

        { $match: { memberType: doc.memberType, country : doc.country } },

        {

          $group: {

            _id: {memberType:"$memberType",country:"$country"},

            memberCount: { $sum: {$cond:[{$gt: ["$numberOfInvitees",0]},1,0]} },

            sameCount: { $sum: {$cond:[{$eq: ["$numberOfInvitees",doc.numberOfInvitees]},1,0]} }

          }

        }

      ]).toArray();

    });

**My question is how can I do this using single aggregate query?**

can any one help me pls :)

[sjmi...@gmail.com]

You can add currentDate in _id for the group pipeline.

$group : {
           _id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" }, memberType:"$memberType",

country:"$country"

 }

https://docs.mongodb.com/manual/reference/operator/aggregation/group/

So now you will get summary for per day per your group in single query.

[Chris Cunningham]

Shaishab,

This question was also posted on Stackoverflow and has been answered.

Thanks

Chris

​