嵌套数据中的mongo db删除密钥

Question

Mongo数据库数据在这里我想删除report_data的密钥 因此，II将发送key = ber2，report_name =删除测试，name =新文件夹它将仅从该报告和文件夹

    {
        "_id" : ObjectId("6267b4554cbd527bee4c6b3a"),
        "structure" : [
            {
                "name" : "New folder",
                "values" : [
                    {
                        "report_name" : "mixll",
                        "report_heading" : "mixll",
                        "background" : "#f0f2f5",
                        "grid" : false,
                        "report_data" : {
                            "mixchch" : {
                                "datasource" : "New_DGR",
                                "source" : "10",
                                "title" : "mix chch"
                            }
                        },
                        "unique_report_name" : "mixll"
                    },
                    {
                        "report_name" : "Delete test",
                        "report_heading" : "Delete test",
                        "background" : "#f0f2f5",
                        "grid" : false,
                        "report_data" : {
                            "ber2" : {
                                "data" : null,
                                "datasource" : "Restest_0423",
                                "source" : "10",
                                "title" : "ber 2"
                            },
                            "piechart" : {
                                "data" : null,
                                "datasource" : "Restest_0423",
                                "source" : "10",
                                "title" : "pie chart"
                            },
                            "lnechart" : {
                                "data" : null,
                                "datasource" : "Restest_0423",
                                "source" : "10",
                                "title" : "lne chart"
                            }
                        },
                        "unique_report_name" : "Deletetest"
                    },
                ],
                "type" : 1
            },
            {
                "name" : "newdkdd",
                "values" : [
                    {
                        "report_name" : "aldkkd",
                        "report_heading" : "aldkkd",
                        "background" : "#f0f2f5",
                        "grid" : false,
                        "report_data" : {
                            "sslsls" : {
                                "datasource" : "alias",
                                "source" : "3",
                                "title" : "sslsls"
                            }
                        },
                        "unique_report_name" : "aldkkd"
                    }
                ],
                "type" : 1
            }
        ],
        "unique_report_id" : 986219
    }

pymongo mongo询问

mycol.update_one({
    "structure.name": folder_name
    },
    {
    "$pull": {
            "structure.$[structure].values": {
            "report_name": report_name,
        }
    }},
    array_filters= [
        {
            "structure.name": folder_name
        }
    ],
upsert=True)

我使用上述查询来删除整个报告中， 将仅删除recort_data的键ber2。 我如何从report_data键中删除一个键，

请看看

Answer 1

使用过滤的位置操作员和ArrayFilters思考，您需要使用report_data.ber2指定密钥，以通过$ unset删除相应的字段。

db.collection.update({
  "structure.name": "New folder"
},
{
  "$unset": {
    "structure.$[structure].values.$[value].report_data.ber2": ""
  }
},
{
  arrayFilters: [
    {
      "structure.name": "New folder",
      
    },
    {
      "value.report_name": "Delete test"
    }
  ]
})