mongodb 3.6 arrayFilters 需要一个顶级字段名称

Question

我正在尝试使用 arrayFilters 更新嵌套数组，根据文档，它似乎应该可以工作，但我遇到了错误:

Error parsing array filter: Expected a single top-level field name, found 'w' and 'd'

查询看起来像这样:

db.getCollection("timesheets").update( {
     "year": "2018",
     "month": "06"    },    {
     "$set": {
       "workers.$[w].days.$[d]": {
         "day": 9,
         "month": "06",
         "year": "2018",
         "isHoliday": false,
         "isSaturday": true,
         "isSunday": false,
         "canEditPlanned": true
       }
     }    },   {
     "arrayFilters": [
       {

             "w._id": "XT5PFAPN9TFY3jXtJ",
             "d.day": 9

       }
     ]    })

Answer 1

当使用 arrayFilters 到 update a nested array 时，过滤器的每个嵌套级别都需要在其自己的 arrayFilters 数组元素中定义:

db.getCollection("timesheets").update({
    "year": "2018",
    "month": "06"
  }, {
    "$set": {
      "workers.$[w].days.$[d]": {
        "day": 9,
        "month": "06",
        "year": "2018",
        "isHoliday": false,
        "isSaturday": true,
        "isSunday": false,
        "canEditPlanned": true
      }
    }
  }, {
    "arrayFilters": [
      {
         "w._id": "XT5PFAPN9TFY3jXtJ"
      },
      {
         "d.day": 9
      }
    ]
  })