MongoTemplate翻译Java Aggregate

陆贝伊 2020-09-16 12:45:06
如下Mongo语句如何转换为Java,求大牛解答

db.order_report.aggregate([{
"$match": {
"userId": 2
}
}, {

"$unwind": "$content"
}, {
"$project": {
"userId": 1,
"createTime": 1,
"content": [
{
"pageId": "$content.pageId",
"sop2": {
"send": {
"$sum": "$content.sop2.send"
},
"read": {
"$sum": "$content.sop2.read"
},
"delivery": {
"$sum": "$content.sop2.delivery"
},
"orderCount": {
"$sum": "$content.sop2.orderCount"
}
},
"workFlow": {
"send": {
"$sum": "$content.workFlow.send"
},
"read": {
"$sum": "$content.workFlow.read"
},
"delivery": {
"$sum": "$content.workFlow.delivery"
},
"orderCount": {
"$sum": "$content.workFlow.orderCount"
}
},
"broadcast": {
"send": {
"$sum": "$content.broadcast.send"
},
"read": {
"$sum": "$content.broadcast.read"
},
"delivery": {
"$sum": "$content.broadcast.delivery"
},
"orderCount": {
"$sum": "$content.broadcast.orderCount"
}
}
}
]
}
}, {
"$unwind": "$content"
}, {
"$group": {
"_id": {
"createTime": "$createTime",
"userId": "$userId"
},
"content": {
"$push": "$content"
},

}
}, {
"$project": {
"_id": false,
"userId": "$_id.userId",
"createTime": "$_id.createTime",
"content": "$content"
}
}])


...全文
75 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

1,747

社区成员

发帖
与我相关
我的任务
社区描述
MongoDB相关内容讨论区
社区管理员
  • MongoDB社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧