java - Mongodb $lookup 查询获取别名为空白

Question

db.ticket.aggregate([
  {
    $lookup: {
      from: "crmorder",
      localField: "subOrderId",
      foreignField: "currentStatus",
      as: "comments"
    }
  }
])

结果评论字段为什么变成空白？

Answer 1

您还有一张名为 crmorder 的表

工单表中必须有 - subOrderId 字段

在 crmorder 表中必须有 - currentStatus 字段

还有工单表 subOrderId 字段 == crmorder 表 currentStatus 字段

这里是示例片段:

db.orders.insert([
   { "_id" : 1, "item" : "almonds", "price" : 12, "quantity" : 2 },
   { "_id" : 2, "item" : "pecans", "price" : 20, "quantity" : 1 },
   { "_id" : 3  }
])

db.inventory.insert([
   { "_id" : 1, "sku" : "almonds", description: "product 1", "instock" : 120 },
   { "_id" : 2, "sku" : "bread", description: "product 2", "instock" : 80 },
   { "_id" : 3, "sku" : "cashews", description: "product 3", "instock" : 60 },
   { "_id" : 4, "sku" : "pecans", description: "product 4", "instock" : 70 },
   { "_id" : 5, "sku": null, description: "Incomplete" },
   { "_id" : 6 }
])

db.orders.aggregate([
   {
     $lookup:
       {
         from: "inventory",
         localField: "item",
         foreignField: "sku",
         as: "inventory_docs"
       }
  }
])