1、group分组后想展示主键_id字段
比如分组之后显示,会发现_id是分组后的一个大文本,不是这条数据的主键_id,这是如果想显示主键_id,如何展示呢?
db.summary_copy.aggregate([{"$match":{"work_no":{$in:["11111111111"]}}},{"$sort":{"work_no":1,"item_id":1}},
{"$group": {"_id": {"work_no":"$work_no","item_id":"$item_id","copy_type":"$copy_type"}, "count": {"$sum": 1}}},
{"$match": {"count": {"$gte": 1}}},
{"$project":{"_id":1,"id":1,"work_no":1,"item_id":1,"copy_type":1}}
])
$first改进之后的效果
db.summary_copy.aggregate([{"$match":{"work_no":{$in:["11111111111"]}}},{"$sort":{"work_no":1,"item_id":1}},
{"$group": {"_id": {"work_no":"$work_no","item_id":"$item_id","copy_type":"$copy_type"}, "count": {"$sum": 1},"id":{"$first":"$_id"},"work_no":{"$first":"$work_no"},"item_id":{"$first":"$item_id"},"copy_type":{"$first":"$copy_type"}}},
{"$match": {"count": {"$gte": 1}}},
{"$project":{"_id":0,"id":1,"work_no":1,"item_id":1,"copy_type":1}},
])