我有一个这样的文件集:

{
    "Company" : "4433",
    "Descripcion" : "trabajo",
    "Referencia" : "11817",
    "HoraImportado" : "15:54",
    "ImportedOd" : "2014-05-20T13:54:28.493Z",
    "Items" : [],
    "Notes" : [ 
        {
            "_id" : ObjectId("537b5ea4c61b1d1743f43420"),
            "NoteDateTime" : "2014-05-20T13:54:44.418Z",
            "Description" : "nota",
            "IsForTechnician" : true,
            "Username" : "admin"
        }, 
        {
            "_id" : ObjectId("537c4a549e956f77ab8c7c38"),
            "NoteDateTime" : ISODate("2014-05-21T06:40:20.299Z"),
            "Description" : "ok",
            "IsForTechnician" : true,
            "Username" : "admin"
        }
    ],
    "OrderState" : "Review",
    "SiniestroDe" : "Emergencia",
    "Technicians" : [ 
        {
            "TechnicianId" : ObjectId("53465f9d519c94680327965d"),
            "Name" : "Administrator",
            "AssignedOn" : ISODate("2014-05-20T13:54:44.373Z"),
            "RemovedOn" : null
        }
    ],
    "TechniciansHistory" : [ 
        {
            "TechnicianId" : ObjectId("53465f9d519c94680327965d"),
            "Name" : "Administrator",
            "AssignedOn" : ISODate("2014-05-20T13:54:44.373Z"),
            "RemovedOn" : null
        }, 
        {
            "Name" : "Nuevo",
            "AssignedOn" : ISODate("2014-05-20T13:54:44.373Z"),
            "RemovedOn" : null,
            "TechnicianId" : ObjectId("5383577a994be8b9a9e3f01e")
        }
    ],
    "Telefonos" : "615554006",
    "_id" : ObjectId("537b5ea4c61b1d1743f4341f"),
    "works" : [ 
        {
            "code" : "A001",
            "name" : "Cambiar bombilla",
            "orderId" : "537b5ea4c61b1d1743f4341f",
            "price" : "11",
            "ID" : 33,
            "lazyLoaded" : true,
            "status" : 0,
            "Date" : ISODate("2014-05-21T06:40:20.299Z"),
            "TechnicianId" : "53465f9d519c94680327965d",
            "_id" : ObjectId("537c4a549e956f77ab8c7c39")
        }, 
        {
            "code" : "A001",
            "name" : "Cambiar bombilla",
            "orderId" : "537b5ea4c61b1d1743f4341f",
            "price" : "11",
            "ID" : 34,
            "lazyLoaded" : true,
            "status" : 0,
            "Date" : ISODate("2014-05-21T06:40:20.299Z"),
            "TechnicianId" : "53465f9d519c94680327965d",
            "_id" : ObjectId("537c4a549e956f77ab8c7c3a")
        }
    ]
}

现在我想获取选定的 TechnicianId 数组的作品，按 TechnicianId 分组并获取每个技术人员的作品的总和。价格。+

我试试这个:

db.orders.aggregate([
                     { $match: { 'works.TechnicianId': {$in:['53465f9d519c94680327965d']}}},
                     { $group: { _id: "$works.TechnicianId",total:{$sum:'$works.price'}}},
                   ])

这是结果:

{
    "result" : [ 
        {
            "_id" : [ 
                "53465f9d519c94680327965d", 
                "53465f9d519c94680327965d"
            ],
            "total" : 0
        }
    ],
    "ok" : 1
}

总数是 $sum 但它是 0 但应该是 44。

最佳答案

尝试添加放松，

db.orders.aggregate([
                 { $match: { 'works.TechnicianId': {$in:['53465f9d519c94680327965d']}}},
                 { $unwind: "$works" },
                 { $group: { _id: "$works.TechnicianId",total:{$sum:'$works.price'}}},
               ])

查看此处了解更多信息:http://docs.mongodb.org/manual/reference/operator/aggregation/unwind/

关于MongoDB 聚合 $match 和 $group 与 $sum，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/23885106/