mongodb数据分组按字符串split

db.getCollection('users').aggregate([
    {$match:{ZWBH:11}},
    {$unwind:'$UUID'},
    {$project : { PM : { $split: ["$UUID.name", " "] } } },
    {$project: {PM:{ $arrayElemAt: [ "$PM", 0 ]}}},
    {$project: {PM:{ $toLower: "$PM"}}},
    {$group:{_id:'$PM',sum:{$sum:1}}},
     {$sort:{sum:-1}}
])

分组用户所用的手机品牌数量，其中UUID的格式是：

"UUID" : [ 
        {
            "id" : "xxxxxx",
            "name" : "HUAWEI DUK-AL20"
        }
    ],

 

转载于:https://www.cnblogs.com/slmk/p/10175197.html