更新双嵌套数组 mongodb [英] Update double nested array mongodb

问题描述

我有以下包含双重嵌套数组格式的文档.当someKey":somevalue"和Company":Company1"和Name":Nandhi"时，我必须将级别"字段更新为高级工程师".

I have the below document which contains double nested array format. I have to update the "level" field to "Senior Engineer" when the "someKey":"somevalue" and "Company":"Company1" and "Name":"Nandhi".

文档

    { 
        "_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.请就此提出建议！

As you can seen that, the modifiedCount returns 0. Please advice on this!

推荐答案

需要为每一级嵌套定义arrayFilter，试试:

You need to define arrayFilter for every level of nesting, try:

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

这篇关于更新双嵌套数组 mongodb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！