【mongo】更新集合中所有文档的嵌套文档内的某个字段

宋大米Pro

已于 2024-08-10 14:01:39 修改

阅读量37

点赞数

文章标签： java mongodb spring boot spring cloud mybatis mysql

于 2024-08-10 14:01:26 首次发布

本文链接：https://blog.csdn.net/MS_SONG/article/details/141090009

版权

文章目录

文档结构
更新语句

更新集合 tn_customer_task_aggregate 中文档内嵌入文档 businessScopes 中字段 creditControl；
是 1100的更新为 6000

文档结构

{
    "_id": ObjectId("66b4b1df8fc9cc2d481b72de"),
    "tnMdTaskAggregate": {
        "applyUser": "225462",
        "applyUserName": "225462",
        "taskNo": "CTDJ202307040001",
        "taskType": "CUST_FREEZE"
    },
    "attachmentList": [
        {
            "fileName": "合同审批表_20230704134742A019.jpg",
            "fileUrl": "http://192.168.36.105:8080/profile/upload/2023/07/04/合同审批表_20230704134742A019.jpg"
        },
 
    ],
    "businessScopes": [
        {
            "acctCode": "1515322",
            "creditControl": "6000"
            }
        }
    ],
    "_class": "com.tncloud.matrix.mdm.aggregate.TnMdCustomerTaskAggregate"
}

更新语句

// 等同于mysql
//update tn_md_cust_busi_scope set company = "6000", update_time = NOW() where company = "1100";

db.tn_customer_task_aggregate.updateMany(
    {
        "tnMdTaskAggregate.examStatus": "5",
        "tnMdTaskAggregate.taskStatus": "0",
        "businessScopes.company": "1100"
    },
    {
        $set: {
            "businessScopes.$[elem].company": "6000"
        }
    },
    {
        arrayFilters: [{
            "elem.company": "1100"
        }]
    }
)