MongoDB counts multiple fields

Question

Here is the input collection :

{"itemName" : "A1", "voteType" : "up"}
{"itemName" : "A1", "voteType" : "up"}
{"itemName" : "A1", "voteType" : "down"}
{"itemName" : "A2", "voteType" : "up"}
{"itemName" : "A2", "voteType" : "down"}
{"itemName" : "A2", "voteType" : "down"}
{"itemName" : "A2", "voteType" : "down"}
and so on...

Does anyone know how to get the following documents with Aggregation?

Also, how can we use Spring Data to implement this?

{ "id" : "A1", "CountUp" : 2, "CountDown" : 1}
{ "id" : "A2", "CountUp" : 1, "CountDown" : 3}

Kevin Brady · Accepted Answer · 2015-02-04 13:39:15Z

2

this should work. The $cond operator can be used to populate the CountUp and CountDown fields. After that its just grouping the data

     {
         $project:
           {
             itemName: 1,
             countUp:
               {
                 $cond: [ { $eq: [ "$voteType", "up" ] }, 1, 0 ]
               },
               countdown:
               {
                 $cond: [ { $eq: [ "$voteType", "down" ] }, 1, 0 ]
               }
           }
      },

     { $group : { _id : "$itemName", countUp: { $sum: "$countUp" }, countDown: { $sum: "$countdown" } }}

edited Feb 4, 2015 at 13:39

answered Feb 4, 2015 at 12:16

Kevin Brady

1,72420 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

MongoDB counts multiple fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related