这就是我的文档的样子
{
code: "A2df",
clicks: 7,
countries: [{"country":"IN", clicks:5},{"country":"US", clicks:2}],
domains: [{"domain":"a.com", clicks:4},{"country":"b.com", clicks:3}]
},
{
code: "B3ws",
clicks: 11,
countries: [{"country":"IN", clicks:6},{"country":"ND", clicks:5}],
domains: [{"domain":"a.com", clicks:7},{"country":"c.com", clicks:4}]
},
{
code: "A2df",
clicks: 5,
countries: [{"country":"IN", clicks:2},{"country":"ND", clicks:3}],
domains: [{"domain":"a.com", clicks:1},{"country":"c.com", clicks:4}]
}...
这就是我需要的:
{
code: "A2df",
clicks: 12,
countries: [
{
"country": "IN",
clicks: 7
},
{
"country": "US",
clicks: 2
},
{
"country": "ND",
clicks: 3
}
],
domains: [
{
"domain": "a.com",
clicks: 5
},
{
"country": "b.com",
clicks: 3
},
{
"country": "c.com",
clicks: 4
}
]
}
我知道如何在多个查询中执行此操作 . 我可以对点击进行组聚合和求和,展开数组然后对它们进行分组,然后对它们求和 . 但我想跳过向数据库发出三个请求然后合并三个结果的痛苦 .
在MongoDB中是否有一种方法可以在单个查询中完成所有这些操作 . 我无法改变文件的结构 . 任何帮助表示赞赏 . 即使这不能在单个查询中完成,也可以通过任何建议来减轻痛苦 . :)
这是我到目前为止尝试在单个查询中使用它:
[
{
$match: {
date: {
$gte: fromDate,
$lt: toDate
},
brand_id: brandId,
type: "item"
}
},
{
$unwind: "$countries"
},
{
$group: {
_id: {
code: "$code",
},
clicks: {
$sum: "$countries.clicks"
},
countries: {
$push: "$countries"
}
}
},
{
$unwind: "$domains"
},
{
$group: {
_id: {
code: "$code",
},
clicks: {
$sum: "$domains.clicks"
},
domains: {
$push: "$domains"
}
}
}
]
这将返回一个空数组,但如果我只是进行第一次展开和分组,它会为我提供所需的国家/地区输出 . 这就是我想要解决的问题,尝试在一个查询中获取所有内容 .
1 回答