mongodb多字段分组统计、多表联查脚本
db.T_ZXJC_FQXSSJB.aggregate([ { $group: { _id: {"pwxkzbh":"$pwxkzbh","xkpfkwybm":"$xkpfkwybm","dwmc":"$dwmc","pfkmc":"$pfkmc"}, maxtime: { $max: '$data_time'},maxid:{$max:"$_id"} } }, { $lookup: {from: "T_ZXJC_FQXSSJB", localField:"maxid", foreignField:"_id", as: "tb2"}}, { $project: { "_id": 0, "WrState":"$tb2.WrState","pwxkzbh":"$_id.pwxkzbh","xkpfkwybm":"$_id.xkpfkwybm","dwmc":"$_id.dwmc","pfkmc":"$_id.pfkmc" } } ])