mongodb数据合并设计_MongoDB：将来自多个集合的数据合并为一个..how？

在聚合中对多个集合使用多个$ lookup

查询：

db.getCollection('servicelocations').aggregate([

{

$match: {

serviceLocationId: {

$in: ["36728"]

}

}

},

{

$lookup: {

from: "orders",

localField: "serviceLocationId",

foreignField: "serviceLocationId",

as: "orders"

}

},

{

$lookup: {

from: "timewindowtypes",

localField: "timeWindow.timeWindowTypeId",

foreignField: "timeWindowTypeId",

as: "timeWindow"

}

},

{

$lookup: {

from: "servicetimetypes",

localField: "serviceTimeTypeId",

foreignField: "serviceTimeTypeId",

as: "serviceTime"

}

},

{

$unwind: "$orders"

},

{

$unwind: "$serviceTime"

},

{

$limit: 14

}

])

结果：

{

"_id" : ObjectId("59c3ac4bb7799c90ebb3279b"),

"serviceLocationId" : "36728",

"regionId" : 1.0,

"zoneId" : "DXBZONE1",

"description" : "AL HALLAB REST EMIRATES MALL",

"locationPriority" : 1.0,

"accountTypeId" : 1.0,

"locationType" : "SERVICELOCATION",

"location" : {

"makani" : "",

"lat" : 25.119035,

"lng" : 55.198694

},

"deliveryDays" : "MTWRFSU",

"timeWindow" : [

{

"_id" : ObjectId("59c3b0a3b7799c90ebb32cde"),

"timeWindowTypeId" : "1",

"Description" : "MORNING",

"timeWindow"