mongodb合并多个数组字段并对数组里一个对象的属性进行分组统计

ShenSJay

已于 2022-02-16 18:00:38 修改

阅读量1.8k

点赞数

文章标签： mongodb

于 2022-02-16 17:54:27 首次发布

本文链接：https://blog.csdn.net/qq_32234855/article/details/122968496

版权

需求，有五个数组字段，数组里面是一个个对象，对象有一个相同的属性字段，对该字段分组：
在这里插入图片描述
结果：

aggregate语句：

db.tablename.aggregate()
    .match({companyName:{$in:["xxxxxxxxxxx"]}})
    .project({"influenceRisks.riskPoint": 1,"incomeRisks.riskPoint":1, "complaintRisks.riskPoint": 1,"adverRisks.riskPoint":1,"illegalRisks.riskPoint":1})
    //$setUnion 把多个字段组合成一个之后再unwind
    .project({risks: {$setUnion: ["$influenceRisks","$incomeRisks","$complaintRisks","$adverRisks","$illegalRisks"]}})
    .project({"risks":"$risks.riskPoint"})
    .unwind("$risks")
    .group({
          _id: "$risks",
          count: { $sum: 1}
    })
    .sort({"count": -1})
    .limit(40)

db.tablename.aggregate(
[{ "$match" : { "companyName" : { "$in" : ["xxxxxxxxxx"] } } }, 
{ "$project" : 
{'influenceRisks.riskPoint': 1,'incomeRisks.riskPoint':1, 'complaintRisks.riskPoint': 1,'adverRisks.riskPoint':1,'illegalRisks.riskPoint':1,
risks: {$setUnion: ['$influenceRisks','$incomeRisks','$complaintRisks','$adverRisks','$illegalRisks']},
"risk":"$risks.riskPoint"}},
{ "$unwind" : "$risk" }, { "$group" : { "_id" : "$risk", "count" : { "$sum" : 1 } } }, { "$sort" : { "count" : -1 } },{ "$limit" : 40 }]
)

mongoTemplate 的api没有组装出来，然后…
很不优雅

    private static String pipline = "{aggregate: 'tablename', pipeline:[{ '$match' : { 'companyName' : { '$in' : ['nameStr'] } } }, \n" +
            "{ '$project' : \n" +
            "{'influenceRisks.riskPoint': 1,'incomeRisks.riskPoint':1, 'complaintRisks.riskPoint': 1,'adverRisks.riskPoint':1,'illegalRisks.riskPoint':1,\n" +
            "risks: {$setUnion: ['$influenceRisks','$incomeRisks','$complaintRisks','$adverRisks','$illegalRisks']},\n" +
            "'risk':'$risks.riskPoint'}},\n" +
            "{ '$unwind' : '$risk' }, { '$group' : { '_id' : '$risk', 'count' : { '$sum' : 1 } } }, { '$sort' : { 'count' : -1 } },{ '$limit' : 50 }]}";
 //todo 传参进去把nameStr替换调
 Document document = mongoTemplate.executeCommand(pipline)