我有一个 MongoDB 查询，我想弄明白。我想按日期和另一个字段(投资组合)对我的数据进行分组，并获取该分组中每个 buildResult 的计数。

示例数据如下所示:

    {
            "_id" : ObjectId("52dea764e4b0a491abb54102"),
            "type" : "build",
            "time" : ISODate("2014-01-21T16:59:16.642Z"),
            "data" : {
                    "buildNumber" : 35,
                    "buildDuration" : 1034300,
                    "portfolio" : "Shared",
                    "buildResult" : "FAILURE"
            }
    }
    {
            "_id" : ObjectId("52dea7b7e4b0a491abb54103"),
            "type" : "build",
            "time" : ISODate("2014-01-21T17:00:39.617Z"),
            "data" : {
                    "buildNumber" : 13,
                    "buildDuration" : 1186028,
                    "portfolio" : "Sample",
                    "buildResult" : "SUCCESS"
            }
    }

我正在拍摄的输出是这样的:

    {
            "result" : [
                    {
                            "_id" : {
                                    "month" : 2,
                                    "day" : 28,
                                    "year" : 2014,
                                    "portfolio" : "Shared"
                            },
                            "aborted" : 3,
                            "failure" : 0,
                            "unstable" : 0,
                            "success" : 34
                    },
                    {
                            "_id" : {
                                    "month" : 2,
                                    "day" : 28,
                                    "year" : 2014,
                                    "portfolio" : "Sample"
                            },
                            "aborted" : 3,
                            "failure" : 2,
                            "unstable" : 0,
                            "success" : 37
                    }
            ],
            "ok" : 1
    }

我当前的查询是:

db.builds.aggregate([    
    { $match: { "data.buildResult" : { $ne : null} }},
    { $group: {          
        _id: {              
            month: { $month: "$time" },             
            day: { $dayOfMonth: "$time" },             
            year: { $year: "$time" },   
            portfolio: "$data.portfolio",                    
        },         
        aborted: { $sum: { "$data.buildResult": "ABORTED" } },
        failure: { $sum: { "$data.buildResult": "FAILURE" } },
        unstable: { $sum: { "$data.buildResult": "UNSTABLE" } },
        success: { $sum: { "$data.buildResult": "SUCCESS" } }
    } },     
    { $sort: { "_id.day": 1, "_id.month": 1, "_id.year": 1 } } 
])

我尝试了以下行的多种变体，包括 $match、$in 和其他运算符。任何帮助将不胜感激。

aborted: { $sum: { "$data.buildResult": "ABORTED" } },
failure: { $sum: { "$data.buildResult": "FAILURE" } },
unstable: { $sum: { "$data.buildResult": "UNSTABLE" } },
success: { $sum: { "$data.buildResult": "SUCCESS" } }

最佳答案

要实现这一点，您可以使用 $cond和 $eq运营商是这样的:

aborted: {$sum: {$cond : [{$eq : ["$data.buildResult", "ABORTED"]}, 1, 0]}}

编辑: 如 Neil Lunn 所述在注释中，此处的 $cond 无关紧要，因为 $eq 运算符已经返回 0 或 1。

aborted: {$sum: {$eq : ["$data.buildResult", "ABORTED"]}}

关于MongoDB 聚合计数基于值，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/22149134/