mongodb - 更新双嵌套数组mongodb

下面的文档包含双嵌套数组格式。当“somekey”：“somevalue”和“company”：“company1”和“name”：“nandhi”时，我必须将“level”字段更新为“高级工程师”。
文件

    {
        "_id" : "777",
        "someKey" : "someValue",
        "someArray" : [
            {
                "Company" : "Company1",
                "someNestedArray" : [
                    {
                        "name" : "Nandhi",
                        "level" : "Junior Engineer"
                    },
                    {
                        "name" : "Rajan",
                        "level" : "Senio Engineer"
                    }
                ]
            }],
            {
                "Company" : "Company2",
                "someNestedArray" : [
                    {
                        "name" : "Nandhi",
                        "level" : "Junior Engineer"
                    },
                    {
                        "name" : "Rajan",
                        "level" : "Senio Engineer"
                    }
                ]
            }
        ]
    }

更新我尝试的查询

    db.Test123.updateOne(
    {"someKey" : "someValue","someArray.Company":"Company1"},
    {$set:{"someArray.$[someNestedArray].level":"Senior Developer"}},
    {arrayFilters:[{"someNestedArray.name":"Nandhi"}]}
    );

输出屏幕截图

如您所见，modifiedCount返回0。请给我建议！

最佳答案

您需要为每个嵌套级别定义ArrayFilter，请尝试：

db.Test123.update(
    { "someKey" : "someValue" },
    { "$set": { "someArray.$[someArrayDoc].someNestedArray.$[someNestedArrayDoc].level": "Senior Developer" } },
    { arrayFilters: [ {"someArrayDoc.Company": "Company1"}, { "someNestedArrayDoc.name": "Nandhi" } ] }
)