monggo 中聚合函数分组查询 以organization下的每个内容进行分组 怎样做

Question

/* 1 */
{
    "_id" : ObjectId("60d14115519f7346ebbfdb0e"),
    "name" : "Amar Ramasar",
    "cover_url" : "https://vod.cncvpro.com/image/default/EDE716D04202AECB853232C1719C-6-2.png",
    "image_path" : "3/7/entry_5/4cc9481269586f975df4cc72b97ee3a.png",
    "description" : "",
    "organization" : {
         ObjectId("60d140b5519f7346ebbfd4ea"),
         ObjectId("60d140b5519f7346ebbfd4aa"),
         ObjectId("60d140b5519f7346ebbfd4ae"),
         ObjectId("60d140b5519f7346ebbfd4cc")
    },
    "creator" : {
        "id" : ObjectId("60d140b5519f7346ebbfd5ba")
    },
    "video_info" : {
        "width" : 1280,
        "height" : 720,
        "duration" : 376
    },
    "status" : 3,
    "old_id" : 5,
    "old_status" : "ready",
    "platforms" : "alivod",
    "_created" : ISODate("2019-01-10T20:53:34.000+08:00"),
    "_updated" : ISODate("2019-05-14T23:16:33.000+08:00"),
    "channel_id_list" : [ 
        ObjectId("60d140b8519f7346ebbfd7c1")
    ],
    "channels" : [ 
        {
            "id" : ObjectId("60d140b8519f7346ebbfd7c1"),
            "name" : "American Doers"
        }
    ],
    "alvoid_status" : 5,
    "disk_space_in_byte" : 132779012,
    "file_size_in_byte" : 57849820,
    "video_id" : "7b79f6414b2d4af28292053ff877ea96",
    "video_path" : "http://outin-b0d9a27cx1511e9906100163e1c94a4.oss-cn-shanghai.aliyuncs.com/customerTrans/906b40217ba700cc76sc49e704fe71e/b13a811-16ab531bf92-0006-f349-271-b1805.mp4"
}

/* 2 */
{
    "_id" : ObjectId("60d14115519f7346ebbfdb0f"),
    "name" : "Kelly Hallman",
    "cover_url" : "https://vod.cncvpro.com/image/default/5E325519E3F84CD895455168E9F23BFB-6-2.png",
    "image_path" : "3/7/entry_6/46c61b87a5bb5c1a788f6507cdea842f.png",
    "description" : null,
    "organization" : {
        "id" : ObjectId("60d140b5519f7346ebbfd4ea")
    },
    "creator" : {
        "id" : ObjectId("60d140b5519f7346ebbfd5ba")
    },
    "video_info" : {
        "width" : 1280,
        "height" : 720,
        "duration" : 228
    },
    "status" : 3,
    "old_id" : 6,
    "old_status" : "ready",
    "platforms" : "alivod",
    "_created" : ISODate("2019-01-10T20:58:37.000+08:00"),
    "_updated" : ISODate("2019-05-14T23:16:02.000+08:00"),
    "channel_id_list" : [ 
        ObjectId("60d140b8519f7346ebbfd7c1")
         ObjectId("60d140b5519f7346ebbfd4vv"),
         ObjectId("60d140b5519f7346ebbfd4cc"),
         ObjectId("60d140b5519f7346ebbfd4ea"),
         ObjectId("60d140b5519f7346ebbfd4cc")
    ],
    "channels" : [ 
        {
            "id" : ObjectId("60d140b8519f7346ebbfd7c1"),
            "name" : "American Doers"
        }
    ],
    "alvoid_status" : 5,
    "disk_space_in_byte" : 79149324,
    "file_size_in_byte" : 32643288,
    "video_id" : "ae3836b4594041beb558bda9afdfe19b",
    "video_path" : "https://vod.cncvpro.com/customerTrans/906b40217ba700cc7653c49e704fe71e/10b58c59-16ab531bcc0-0006-f349-271-b1805.mp4"
}

这是两段monggo 数据  

monggo 中聚合函数分组查询 数量   想以organization下的每个内容进行分组  应该 怎样做

Answer 1

MongoDB中可以使用$group聚合函数来实现以organization下的每个内容进行分组的查询，具体语法如下：

db.collection.aggregate([
    {
        $group: {
            _id: "$organization",
            content: {$push: "$content"}
        }
    }
])