從mongoDb嵌套陣列中過濾掉專案并添加新欄位-有解無憂

有一個 mongoDb 集合，如下所示：

[
  {
    "_id": {
      "$oid": "63110728d74738cdc48a7de0"
    },
    "listName": "list_name",
    "alloweUidList": [
      {
        "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
        "role": "creator",
        "boolId": 1,
        "crDate": "2022-09-01 21:25",
        "modDate": null
      }
    ],
    "offerModelList": [
      {
        "offerListenerEntity": {
          "_id": "6311072ed74738cdc48a7de1",
          "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
          "itemName": "sometehing",
          "crDate": "2022-09-01 21:25",
          "boolId": 1,
          "modDate": null,
          "imageColorIndex": 3,
          "shoppingListId": "63110728d74738cdc48a7de0",
          "checkFlag": 0,
          "itemCount": 1
        },
        "offers": [
          {
            "id": "62fa7983b7f32cc089864a3b",
            "itemId": 127382,
            "itemName": "item_1",
            "itemCleanName": "item_clean_name",
            "imageUrl": "item.png",
            "price": 10,
            "measure": "measure",
            "salesStart": "N.a",
            "source": "source",
            "runDate": "2022.08.15-14:11:15",
            "shopName": "shop_name",
            "isSales": 1,
            "insertType": "automate",
            "timeKey": "2022_08_15_18_51",
            "imageColorIndex": 0,
            "isSelectedFlag": 1,
            "selectedBy": "not_selected",
            "itemCount": 1
          },
          {
            "id": "62fa7983b7f32cc089864a3b",
            "itemId": 127382,
            "itemName": "item_2",
            "itemCleanName": "item_clean_name",
            "imageUrl": "image.png",
            "price": 20,
            "measure": "measure",
            "salesStart": "N.a",
            "source": "source",
            "runDate": "2022.08.15-14:11:15",
            "shopName": "shop_name",
            "isSales": 1,
            "insertType": "automate",
            "timeKey": "2022_08_15_18_51",
            "imageColorIndex": 0,
            "isSelectedFlag": 0,
            "selectedBy": "not_selected",
            "itemCount": 1
          }
        ]
      },
      {
        "offerListenerEntity": {
          "_id": "6311a5c0d74738cdc48a7de2",
          "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
          "itemName": "anything",
          "crDate": "2022-09-02 08:42",
          "boolId": 1,
          "modDate": null,
          "imageColorIndex": 1,
          "shoppingListId": "63110728d74738cdc48a7de0",
          "checkFlag": 0,
          "itemCount": 2
        },
        "offers": []
      }
    ],
    "crDate": "2022-09-01 21:25",
    "modDate": "2022-09-01 21:25",
    "boolId": 1,
    "imageColorIndex": 1
  }
]

所以它有一個陣列，有一個嵌套陣列。

如果它正在使用此聚合查詢，我想從offerModelList陣列中過濾掉整個專案：offerModelList.offerListenerEntity.boolId == 0

[
  {
    "$match": {
      "alloweUidList": {
        "$elemMatch": {
          "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
          "boolId": 1
        }
      },
      "boolId": 1,
      
    }
  },
  {
    "$addFields": {
      "offerModelList": {
        "$filter": {
          "input": "$offerModelList",
          "as": "i",
          "cond": {
            "$eq": [
              "$$i.offerListenerEntity.boolId",
              1
            ]
          }
        }
      }
    },
    
  }
]

當我嘗試offerModelList.offers根據isSelectedFlag欄位從陣列中過濾掉專案時，問題就來了。

我將查詢修改為：

db.collection.aggregate([
  {
    "$match": {
      "alloweUidList": {
        "$elemMatch": {
          "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
          "boolId": 1
        }
      },
      "boolId": 1,
      
    }
  },
  {
    "$addFields": {
      "offerModelList": {
        "$filter": {
          "input": "$offerModelList",
          "as": "i",
          "cond": {
            "$eq": [
              "$$i.offerListenerEntity.boolId",
              1
            ]
          }
        }
      }
    },
    
  },
  {
    "$addFields": {
      "offerModelList.offers": {
        "$filter": {
          "input": "$offerModelList.offers",
          "as": "x",
          "cond": {
            "$eq": [
              "$$x.isSelectedFlag",
              1
            ]
          }
        }
      }
    },
    
  }
])

問題是，它總是回傳空offers陣列。

這里有一個例子：https : //mongoplayground.net/p/kksRpoNKr1k 在這種特定情況下，優惠陣列應該只包含一項。

uj5u.com熱心網友回復：

不要以為你可以直接從offerModelList.offers.

相反，對于最后階段，

$set- 設定offerModelList欄位。

1.1。$map- 迭代offerModelList陣列中的元素并回傳一個新陣列。

1.1.1。$mergeObjects- 將當前迭代的檔案與1.1.1.1產生的檔案合并。

1.1.1.1。offers帶有陣列的檔案。通過$filter使用過濾檔案isSelectedFlag: 1。

db.collection.aggregate([
  {
    "$match": {
      "alloweUidList": {
        "$elemMatch": {
          "uid": "prQUKkIxljVqbHlCKah7T1Rh7l22",
          "boolId": 1
        }
      },
      "boolId": 1,
      
    }
  },
  {
    "$addFields": {
      "offerModelList": {
        "$filter": {
          "input": "$offerModelList",
          "as": "i",
          "cond": {
            "$eq": [
              "$$i.offerListenerEntity.boolId",
              1
            ]
          }
        }
      }
    },
    
  },
  {
    "$set": {
      "offerModelList": {
        $map: {
          input: "$offerModelList",
          as: "offerModel",
          in: {
            $mergeObjects: [
              "$$offerModel",
              {
                offers: {
                  $filter: {
                    input: "$$offerModel.offers",
                    as: "x",
                    cond: {
                      $eq: [
                        "$$x.isSelectedFlag",
                        1
                      ]
                    }
                  }
                }
              }
            ]
          }
        }
      }
    }
  }
])

演示@Mongo Playground

轉載請註明出處，本文鏈接：https://www.uj5u.com/net/504157.html

標籤：mongodb mongodb查询聚合框架

上一篇：Mongodb在兩個鍵上查找具有日期差異的查詢

下一篇：com.mysql.cj.jdbc.exceptions.CommunicationsException：通信鏈路故障。驅動程式沒有收到來自服務器的任何資料包