MongoDB.ArrayFilters出错：在路径中找不到标识符'；elem'；的数组筛选器

我想更新对象"profileSpheres"的array. 如果"profileSpheres.idq"等于"Q0800"，"profileSpheres.ida"等于"A0810_001"，则"profileSpheres.ida"必须是"A0800_001".

这是link to the playground美元

文件示例:

  {
    "_id": 0,
    "idu": "AA0092",
    "profileSpheres": [
      {
        "idq": "Q0780",
        "ida": "A0780_002",
        "value": null,
        "explain": null,
        "date": "2023-12-26T04:03:57.196Z"
      },
      {
        "idq": "Q0800",
        "ida": "A0810_001",
        "value": null,
        "explain": "encorvar la espalda mucho rato o usar mochilas pesadas ",
        "date": "2023-12-26T04:04:37.679Z"
      },
      {
        "idq": "Q0810",
        "ida": "A0810_002",
        "value": null,
        "explain": null,
        "date": "2023-12-26T04:04:37.755Z"
      },
      {
        "idq": "Q0820",
        "ida": "A0820_002",
        "value": null,
        "explain": null,
        "date": "2023-12-26T04:04:40.411Z"
      }
    ]
  }

这是我的代码:

db.collection.updateMany({
  "idu": "AA0092"
},
{
  "$set": {
    "profileSpheres.$[elem].ida": "A0800_001"
  },
  "arrayFilters": [
    {
      "elem.idq": "Q0800"
    },
    {
      "elem.ida": "A0810_001"
    }
  ]
})