$ lookup与嵌套的对象数组

Arpit yadav

我的文档具有包含多个对象的数组，并且我需要找到相关值并将其放入同一数组。

大车

{
    "_id" : ObjectId("5b2b72119fbb60750e0061b9"),
    "cartId" : "1529573905701",
    "supplierId" : ObjectId("5b221d1b63eda2902418434d"),
    "user_id" : "5b20c54651e68057b3cbe745",
    "createdAt" : ISODate("2018-06-21T09:38:25.680Z"),
    "services" : [ 
        {
            "date" : "21-06-2018",
            "timeSlot_id" : ObjectId("5b29e08cb116c31f5b1f56c6"),
            "time" : "03:30 PM - 04:30 PM",
            "serviceId" : ObjectId("5b24aff4abf2494701bc1c15"),
            "cost" : 250,
            "_id" : ObjectId("5b2b72119fbb60750e0061ba")
        }, 
        {
            "_id" : ObjectId("5b2b72329fbb60750e0061bb"),
            "cost" : 250,
            "serviceId" : ObjectId("5b24aff4abf2494701bc1c15"),
            "time" : "03:30 PM - 04:30 PM",
            "timeSlot_id" : ObjectId("5b29e08cb116c31f5b1f56c6"),
            "date" : "21-06-2018"
        }
    ],
    "__v" : 0
}

服务

{
    "_id" : ObjectId("5b24aff4abf2494701bc1c15"),
    "isActivated" : true,
    "supplierServiceId" : 900146649,
    "serviceId" : 99473640,
    "serviceName" : "AC Reparing",
    "description" : "all type of AC, Split AC and Window AC",
    "cost" : 250,
    "serviceDuration" : "60",
    "startTime" : "07:00 AM",
    "endTime" : "08:30 PM",
    "supplierId" : "5b221d1b63eda2902418434d",
    "createdAt" : ISODate("2018-06-16T06:36:36.091Z"),
    "__v" : 0
}

时隙

{
    "_id" : ObjectId("5b29e08cb116c31f5b1f56c6"),
    "displayString" : "03:30 PM - 04:30 PM",
    "isActivated" : true,
    "startTime" : "15:30 PM",
    "endTime" : "16:30 PM",
    "duration" : "60",
    "createdAt" : ISODate("2018-06-20T05:05:16.405Z"),
    "__v" : 0
}

在CART的服务中，有两个值serviceId和timeSlot_id

*我需要与相关馆藏两者相关的数据。在同一对象内。

Mongo版本-v3.6.5

请帮助解决此问题。提前致谢。

阿什

你需要$unwind的services，以匹配其timeSlot_id和serviceId与_id时隙和另一个集合的ServiceId分别......然后你就可以$group它来启动“回滚”到数组的过程。

如果您有mongodb 3.6版

Cart.aggregate([
  { "$match": { "user_id": _user._id } },
  { "$unwind": "$services" },
  { "$lookup": {
    "from": TimeSlot.collection.name,
    "let": { "timeSlot_id": "$services.timeSlot_id" },
    "pipeline": [
       { "$match": { "$expr": { "$eq": [ "$_id", "$$timeSlot_id" ] } } }
     ],
     "as": "services.timeSlot_id"
  }},
  { "$lookup": {
    "from": Service.collection.name,
    "let": { "serviceId": "$services.serviceId" },
    "pipeline": [
       { "$match": { "$expr": { "$eq": [ "$_id", "$$serviceId" ] } } }
     ],
     "as": "services.serviceId"
  }},
  { "$unwind": "$services.timeSlot_id" },
  { "$unwind": "$services.serviceId" },
  { "$group": {
    "_id": "$_id",
    "services": { "$push": "$services" },
    "cartId" : { "$first": "$cartId" },
    "supplierId" : { "$first": "$supplierId" },
    "user_id" : { "$first": "$user_id" },
    "createdAt" : { "$first": "$createdAt" }
  }}
])

如果您的mongodb版本低于3.6

Cart.aggregate([
  { "$match": { "user_id": _user._id } },
  { "$unwind": "$services" },
  { "$lookup": {
    "from": TimeSlot.collection.name,
    "localField": "services.timeSlot_id",
    "foreignField": "_id",
    "as": "services.timeSlot_id",
  }},
  { "$lookup": {
    "from": Service.collection.name,
    "localField": "services.serviceId",
    "foreignField": "_id",
    "as": "services.serviceId",
  }},
  { "$unwind": "$services.timeSlot_id" },
  { "$unwind": "$services.serviceId" },
  { "$group": {
    "_id": "$_id",
    "services": { "$push": "$services" },
    "cartId" : { "$first": "$cartId" },
    "supplierId" : { "$first": "$supplierId" },
    "user_id" : { "$first": "$user_id" },
    "createdAt" : { "$first": "$createdAt" }
  }}
])

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。