mongoDB更新子集

db.day_air.updateMany({
    "mp_id": "xx",
    "data_time": ISODate('2025-02-10T00:00:00+08:00')
}, {
    $set: {
        "values.$[i].datasource_code": null,
        "values.$[i].datasource_reason": null,
        "values.$[i].avg_revised": null,
        "values.$[i].datasource_zs_code": null,
        "values.$[i].datasource_zs_reason": null,
        "values.$[i].avg_zs_revised": null,
        "values.$[i].datasource_hm_code": null,
        "values.$[i].datasource_hm_reason": null,
        "values.$[i].avg_hm_revised": null,
        "values.$[i].datasource_zs_hm_code": null,
        "values.$[i].datasource_zs_hm_reason": null,
        "values.$[i].avg_zs_hm_revised": null,
        "values.$[i].rstatus": null,
        "values.$[i].rstatus_reason": null,
        "values.$[i].cou_revised": null,
        "update_time": new Date()
    }
}, {
    arrayFilters: [{
        "$or": [{
            "i.datasource_code": {
                $ne:null
            }
        }, {
            "i.datasource_zs_code": {
                 $ne:null
            }
        }, {
            "i.datasource_hm_code": {
                $ne:null
            }
        }, {
            "i.datasource_zs_hm_code": {
                  $ne:null
            }
        }, {
            "i.rstatus": {
                 $ne:null
            }
        }]
    }]
    ,
    multi: true
})