如下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"
}
}])
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/58484.html
標籤：MongoDB
上一篇：請大佬指點下，我用自己的機器沒法連接測驗環境新裝的oracle！
下一篇：mysql 多表左聯如何去重