我读过 SO 和类似的问题 one .但是我无法构建我想要的查询...

假设我有以下数据结构:

{ 
    "CAUG" : "id1", 
    "action" : "actionA", 
    "date" : ISODate("2017-01-01"), 
    "hp" : 16
}
{ 
    "CAUG" : "id1", 
    "action" : "actionB", 
    "date" : ISODate("2017-01-01"), 
    "hp" : 17
}
{ 
    "CAUG" : "id1", 
    "action" : "actionC", 
    "date" : ISODate("2017-02-10"), 
    "hp" : 18
}
{ 
    "CAUG" : "id2", 
    "action" : "actionX", 
    "date" : ISODate("2018-01-01"), 
    "hp" : 20
}...

所需的输出类似于(不确定括号和其他内容...):

{ 
    "CAUG" : "id1", 
    "timeline" : [
        ISODate ("2017-01-01) {
            { "action" : "ActionA", hp : "..." }
            { "action" : "ActionB", hp : "..." }
        },
        ISODate ("2017-02-10) {
            { "action" : "ActionC", hp : "..." }
        }
    ]
}
{ 
    "CAUG" : "id2", 
    "timeline" : [
        ISODate ("2018-01-01) {
            { "action" : "ActionX", hp : "..." }
        }
    ]
}

此时我的(非常有限的)查询是:

(我尝试过很多东西，比如复合 _id，但我总是卡在某个点上)。

db.aggregate(
    [
        { $match: { something } },
        { $project: { something } },
        { $group: {
              _id: '$CAUG',
              "timeline": { "$push": "$$ROOT"  }
            }
        }
    ]
)

问题是我不知道如何在 timeline 数组中执行另一个 $group...我被下面的输出卡住了...请提供任何线索？周末愉快。

{ 
    "_id" : "1", 
    "timeline" : [
        {
            "CAUG" : "ca220491-ug43816", 
            "action" : "actionA", 
            "date" : ISODate("2016-12-21T23:00:00.000+0000")
        }, 
        {
            "CAUG" : "ca220491-ug43816", 
            "action" : "actionB", 
            "date" : ISODate("2016-12-21T23:00:00.000+0000")
        }, 
        {
            "CAUG" : "ca220491-ug43816", 
            "action" : "actionC", 
            "date" : ISODate("2017-02-21T23:00:00.000+0000")
        }
    ]
}

最佳答案

尝试运行以下聚合操作:

db.collection.aggregate([
    {
        "$group": {
            "_id": {
                "CAUG": "$CAUG",
                "date": {
                    "$dateToString": {
                        "format": "%Y-%m-%d", 
                        "date": "$date"
                    }
                }
            },
            "docs": {
                "$push": {
                    "action" : "$action",
                    "hp" : "$hp"
                }
            }                
        }
    },
    {
        "$group": {
            "_id": "$_id.CAUG",
            "timeline": {
                "$push": {
                    "date": "$_id.date",
                    "docs": "$docs"
                }
            }
        }
    }
])

给出示例输出

/* 1 */
{
    "_id" : "id1",
    "timeline" : [ 
        {
            "date" : "2017-02-10",
            "docs" : [ 
                {
                    "action" : "actionC",
                    "hp" : 18.0
                }
            ]
        }, 
        {
            "date" : "2017-01-01",
            "docs" : [ 
                {
                    "action" : "actionA",
                    "hp" : 16.0
                }, 
                {
                    "action" : "actionB",
                    "hp" : 17.0
                }
            ]
        }
    ]
}

/* 2 */
{
    "_id" : "id2",
    "timeline" : [ 
        {
            "date" : "2018-01-01",
            "docs" : [ 
                {
                    "action" : "actionX",
                    "hp" : 20.0
                }
            ]
        }
    ]
}

关于mongodb - 使用 $group 两次聚合，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/42051079/