$lookup內$lookup在陣列內的物件陣列中

我是 mongoDB 的新手。也許這是一個簡單的問題。請幫我解決這個問題。

在填充值中填充的 mongo 查詢是什么？

有3個表users，bookHistory和books。我需要在所有三個中查找。

這是我需要的結構。

"userList": [
  {
    "_id": "NT-723DD65BE100-444B-B441-2B2804ED7348",
    "name": "AMC",
    "uid": "NT-723DD65BE100-444B-B441-2B2804ED7348",
    "bookHistory": [
      {
        "_id": "SHNH-06E723698ED8-420F-AB6D-6574633F5984",
        "bookStocksId": "SHNC-4559F09A7F4B-4508-9F61-2A2CD248D3F9",
        "bookId": "SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850",
        "uid": "NT-723DD65BE100-444B-B441-2B2804ED7348",
        "bookDetails": {
          "_id": "SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850",
          "nameOfBook": "test",
          "nameOfAuthor": "test authou",
        }
      },
      {
        "_id": "617e6c068bf26821f955b034",
        "bookStocksId": "SHNC-694DF63AE953-40A8-B49B-71E46D0A9463",
        "bookId": "SHN-5B5A2712CE88-46BF-8A5F-F01174316025",
        "uid": "NT-723DD65BE100-444B-B441-2B2804ED7348",
        "bookDetails": {
          "_id": "SHN-5B5A2712CE88-46BF-8A5F-F01174316025",
          "nameOfBook": "test",
          "nameOfAuthor": "test authou",
        }
      }
    ]
  }
]

• 從“用戶”表需要使用 uid 填充“bookHistory”表
• 從 bookHistory 表需要使用 bookId 填充“books”表

是否可以？我正在嘗試此代碼

const pipeline = [
  { $match: query },
  { $project: projection },
  {
    $lookup: {
      from: 'bookHistory',
      localField: 'uid',
      foreignField: 'uid',
      as: 'bookHistory',
    }
  },
];

以下是3張表的樣本資料

1. 用戶表

{ 
  "_id" : "NT-723DD65BE100-444B-B441-2B2804ED7348", 
  "name" : "AMC", 
  "uid" : "NT-723DD65BE100-444B-B441-2B2804ED7348", 
  "updatedBy" : "NT-723DD65BE100-444B-B441-2B2804ED7348", 
  "updatedOn" : ISODate("2021-10-22T02:45:31.320 0000"), 
}

2. 書史

{ 
  "_id" : "SHNH-F10ED64A7F98-480B-8D8F-B7587594FB10", 
  "bookStocksId" : "SHNC-7D60FF3D3E15-4C43-AB24-7E3EA1C0D79A", 
  "bookId" : "SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850", 
  "uid" : "NT-723DD65BE100-444B-B441-2B2804ED7348", 
  "tookOn" : ISODate("2021-10-31T12:59:24.895 0000"), 
  "dueOn" : ISODate("2021-11-07T12:59:24.895 0000"), 
  "addedOn" : ISODate("2021-10-31T12:59:24.895 0000")
}

3. 書桌

{ 
"_id" : "SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850", 
"nameOfBook" : "test", 
"nameOfAuthor" : "test authou", 
"yearOfPublication" : "1998", 
"publication" : "test", 
"addedOn" : ISODate("2021-10-27T08:39:00.147 0000")
}

任何人都可以幫我解決這個問題嗎？

uj5u.com熱心網友回復：

只需在$lookupfrom bookHistorytobooks的子管道中執行另一個$lookupfrom usertobookHistory

db.user.aggregate([
  {
    "$lookup": {
      "from": "bookHistory",
      let: {
        uid: "$uid"
      },
      pipeline: [
        {
          $match: {
            $expr: {
              $eq: [
                "$$uid",
                "$uid"
              ]
            }
          }
        },
        {
          "$lookup": {
            "from": "books",
            "localField": "bookId",
            "foreignField": "_id",
            "as": "bookDetails"
          }
        },
        {
          "$unwind": "$bookDetails"
        }
      ],
      "as": "bookHistory"
    }
  }
])

這是Mongo 游樂場供您參考。

標籤：数组 MongoDB 猫鼬 mongodb-查询 聚合框架

上一篇：在mongodb中查找元素的父元素

下一篇：如何將字串轉換為日期，然后使用mongodb執行過濾器？