我有一个sql背景,并且了解mongodb中聚合数据的语法,但是我在MongoDB中“扁平”多个键聚合的输出时遇到了问题。例如,标准语法如下:
db.transactions.aggregate(
[
{ $group: { _id: {"category":"$category","postdate":"$postdate"} , "total": { $sum: "$total" } } }
]
);但这将以下列形式返回数据:
[{"_id":{"category":"Fees","postdate":"2013-01-04T05:00:00.000Z"},"total":24},
{"_id":{"category":"Fees","postdate":"2012-12-20T05:00:00.000Z"},"total":-0.02}]我想要的是数据的格式,如下所示,我仍然在两个或多个列上分组:
备选案文1:
[{"_id":"Auto","postdate":"2013-01-04T05:00:00.000Z","total":24},
{"_id":"Fees","postdate":"2012-12-20T05:00:00.000Z","total":-0.02}]备选案文2:
["category":"Auto","postdate":"2013-01-04T05:00:00.000Z","total":24},
{"category":"Fees","postdate":"2012-12-20T05:00:00.000Z","total":-0.02}]我如何在mongodb中做到这一点?
发布于 2016-12-08 21:00:09
使用https://docs.mongodb.com/v3.0/reference/operator/aggregation/project/格式化您的响应
备选案文1:
db.transactions.aggregate(
[
{ $group: { _id: {"category":"$category","postdate":"$postdate"} , "total": { $sum: "$total" } } },
{ $project: { "_id":0, "_id":"$_id.category", "postdate":"$_id.postdate", "total":1 } }
]
);备选案文2:
db.transactions.aggregate(
[
{ $group: { _id: {"category":"$category","postdate":"$postdate"} , "total": { $sum: "$total" } } },
{ $project: { "_id":0, "category":"$_id.category", "postdate":"$_id.postdate", "total":1 } }
]
);https://stackoverflow.com/questions/41048484
复制相似问题