Mongodb aggregation in inside a array [duplicate]

Question

I have the below mongo collection structure

    {
   "_id":"some mongo Id",
   "email":"[email protected]",
   "Course1":[
      {
         "sublesson":1,
         "timespent":10,
         "timestamp":"123456"
      },
      {
         "sublesson":1,
         "timespent":20,
         "timestamp":"123457"
      },
      {
         "sublesson":2,
         "timespent":20,
         "timestamp":"123458"
      }
   ]
}

Now, all need is to find the sum of time taken for each sublesson aggregated. I have tried some methods but cannot access the data inside the "course1" array.

Sarthak Sawhney · Accepted Answer · 2019-06-03 05:18:44Z

1

If I can understand the requirement correctly you need to sum up the timespent.

Please give this a try:

db.testing.aggregate(
[
    {
        "$unwind":"$Course1"
    },
    {
        "$group": {
            "_id": "$email", 
            "timespent":
            {
                "$sum":"$Course1.timespent"
            }
        }
    }
]
);

answered Jun 3, 2019 at 5:18

Sarthak Sawhney

4324 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Mongodb aggregation in inside a array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related