$group with nested array in mongodb

Question

I have a collection contains document in this format

  {"_id" : NumberLong(567719019),
   "date" : ISODate("2018-07-17T09:56:57.000Z"),
"conclusion" : [ 
    {
        "rname" : "LAM",
        "rulename" : "_OK"
    }
],
"indication" : [ 
    {
        "rname" : "AM",
        "rulename" : "_STABLE"
    }
],
"error" : [ 
    {
        "errorkey" : "tesd",
        "testname" : "d"
    }, 
    {
        "errorkey" : "v",
        "testname" : "c"
    },
    {
        "errorkey" : "td",
        "testname" : "d"
    }, 
    {
        "errorkey" : "va",
        "testname" : "c"
    }
]

}

So I want to aggregate and group by one or tow element from a table, for example, I want to get all distinct errorkey in my collection and get the maximum appeared error key I tried to work like this

       aggregate([{ $group : {_id : { "errorkeyname": 
     "$error.errorkey"}, count: { $sum: 1 } }},{ $out : "Cllection" }])

but it didn't give a result, any help

Ashh · Accepted Answer · 2018-08-16 10:55:19Z

5

You need to $unwind the error field and then you can simply use $group with error.errorkey

db.collection.aggregate([
  { "$unwind": "$error" },
  { "$group": {
    "_id": "$error.errorkey",
    "count": { "$sum": 1 }
  }},
  { "$sort": { "count": 1 } }
])

answered Aug 16, 2018 at 10:55

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Comments

Senthur Deva · Accepted Answer · 2018-08-16 10:15:31Z

1

Try this $unwind $group $push $addToSet $sort $limit

db.col.aggregate([
    { "$unwind": "$error" },
    { "$group": { "_id": null, "distErrKey": { "$addToSet": "$error.errorkey" }, "data": { "$push": "$$ROOT" } } },
    { "$unwind": "$data" },
    { "$group": { "_id": { "errorkeyname": "$data.error.errorkey" }, "count": { "$sum": 1 }, "distErrKeys": { "$first": "$distErrKey" } } },
    { "$sort": { "count": -1 } },
    { "$limit": 1 }
])

answered Aug 16, 2018 at 10:15

Senthur Deva

7975 silver badges12 bronze badges

1 Comment

Chaouki Over a year ago

Thanks for your response! it gives me an error about allowdiskuse !

Collectives™ on Stack Overflow

$group with nested array in mongodb

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related