Mongodb group and then subgroup

Question

I have some mongo documents like this:

{ "worker_id" : "x", "minutes": [ {"min" : 10, "capacity" : 15}, {"min" : 10, "capacity" : 12}, {"min" : 12, "capacity" : 13}, {"min" : 12, "capacity" : 12} ] }

I want to convert these documents into something like this:

{ "worker_id" : "x", "minutes" : [ { "min" : 10, "capacities": [15,12] }, { "min" : 12, "capacities": [13,12] } ] }

I am totally stuck on this, any help is appreciated.

Brugia.

Ashh · Accepted Answer · 2018-09-22 03:20:52Z

You can try below aggregation

db.collection.aggregate([ { "$unwind": "$minutes" }, { "$group": { "_id": { "worker_id": "$worker_id", "minutes": "$minutes.min" }, "capacities": { "$push": "$minutes.capacity" } }}, { "$group": { "_id": "$_id.worker_id", "minutes": { "$push": { "min": "$_id.minutes", "capacity": "$capacities" } } }}, { "$project": { "worker_id": "$_id", "minutes": 1, "_id": 0 }} ])

Collectives™ on Stack Overflow

Mongodb group and then subgroup

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related