如何在mongo查询中为数组添加键值对[重复]

Question

我不同意将键值对添加到具有相同名称的数组中。有没有办法根据索引添加？

我试着在搜索查询中找到关键字，这很管用。但更新会将其添加到文档的底部

db.getCollection('siteLog').updateOne(
{
    'site':'test1',
    'items.suspiciousActivity.source': 'Account Added to Admin Group'
},
    {$set:
        {'items.suspiciousActivity.source.Account Added to Admin Group' : 'summary':'test1'}
     })

"items" : [ 
        {
            "suspiciousActivity" : {
                "source" : "Account Added to Admin Group",
                "count" : "2",
                "summary" : "Test summary for this"
            }
        }, 
        {
            "suspiciousActivity" : {
                "source" : "Palo Alto FW - Local Account Login",
                "count" : "2",
                "summary" : "Another test summary"
            }
        }, 
        {
            "suspiciousActivity" : {
                "source" : "Suspicious Failed Logon Attempts",
                "count" : "2",
                "summary": "more summaries"
            }
        }, 

Answer 1

您需要使用$获得正确的items索引，如下所示：

db.getCollection('siteLog').updateOne({
    'site': 'test1',
    'items.suspiciousActivity.source': 'Account Added to Admin Group'
}, {
    $set: {
        'items.$.suspiciousActivity.summary': 'test1'
    }
})