How to update MongoDB nested documents locally

MongoDB, there is a piece of data that I want to modify, workerStats.stage=LABEL and workerStats.idOfWorker=admin stats in labeledItems to increase it by 1.

{
    "_id" : ObjectId("5ac1ff4c87c0fc67c0f4fe60"),
    "_class" : "com.JobEntity",
    "workerStats" : [ 
        {
            "idOfWorker" : "admin",
            "stage" : "LABEL",
            "stats" : {
                "totalItems" : 0,
                "labeledItems" : 0,
                "submittedItems" : 0
            }
        }, 
        {
            "idOfWorker" : "lgh",
            "stage" : "REVIEW",
            "stats" : {
                "totalItems" : 0,
                "labeledItems" : 0,
                "submittedItems" : 0
            }
        }
    ]
}

my modification statement is as follows:

db.job.updateOne(
{
    "_id": ObjectId("5ac1ff4c87c0fc67c0f4fe60"),
    "workerStats.stage": "LABEL",
    "workerStats.idOfWorker": "admin"
},
{
    $inc: {
        "workerStats.$.stats.labeledItems": 1
    }
}
)

but it doesn"t work. How should I modify it?

Nested-documents-modify mongodb

Mar.02,2021

$elemMatch means to use the same array element to match multiple conditions at the same time. Otherwise, it may be that multiple array elements match different conditions, and $is meaningless.

db.test.updateOne(
{
    _id: ObjectId("5ac1ff4c87c0fc67c0f4fe60"),
    workerStats: {
        $elemMatch: {
            stage: "LABEL",
            idOfWorker: "admin"
        }
    }
},
{
    $inc: {
        "workerStats.$.stats.labeledItems": 1
    }
})

Previous: Is mongoose's validator invalid for update?

Next: Git merge conflict problem

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b399a7-2c19d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b399a7-2c19d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?