MongoDB: $sum query [duplicate]

Question

For example I have the following data in MongoDB:

  {
    "student": "Pedro",
    "class_id": 10,
    "scores": [
             {
                "type":"exam",
                "score": 10  
             },
             {
                "type":"homework",
                "score": 10  
             }
     ] 
  }

Now I want to query "SUM the scores - score", how could I do this using Mongo Shell?

mickl · Accepted Answer · 2018-03-13 05:59:27Z

1

You can use $reduce which transforms an array to a scalar value:

db.col.aggregate([
    {
        $project: {
            student: 1,
            class_id: 1,
            totalScore: {
               $reduce: {
                  input: "$scores",
                  initialValue: 0,
                  in: { $add : ["$$value", "$$this.score"] }
               }
            }
        }
    }
])

answered Mar 13, 2018 at 5:59

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: $sum query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related