arrays - 更新深度嵌套数组 mongodb

Question

我想使用 mongodb 将一个值推送到附件数组中。我想使用以下条件更新查询。

_id:ObjectId("5b56bd2f3e18580edc85af73") "cardID": ObjectId("5b56c895d0a04836f71aa776") "commentId":"2"

我想提高附件的值(value)，如有任何帮助，我们将不胜感激

这是一个集合对象:

{
            "_id" : ObjectId("5b56bd2f3e18580edc85af73"),
            "orgId" : "90",
            "createdBy" : "test",
            "name" : "testname",
            "Cards" : [ 
                {
                    "cardID" : ObjectId("5b56c895d0a04836f71aa776"),
                    "cardName" : "test Name",
                    "cardCreated" : "",
                    "reviewer" : "",
                    "priority" : "",
                    "cardPosition" : "",
                    "membersAssigned" : [ 
                        "ggg", 
                        "fff"
                    ],
                    "labels" : [ 
                        "l1", 
                        "l2"
                    ],
                    "description" : "",
                    "attachements" : [],
                    "comments" : [ 
                        {
                            "commentId" : "2",
                            "commentedBy" : "test",
                            "date" : "",
                            "comment" : "Hello world",
                            "attachements" : [   
                                "1", 
                                "data"
                            ],
                            "emojis" : [ 
                                ":smile:", 
                                ":thumbsup:"
                            ],
                            "updatedBy" : "arkadata",
                            "updatedOn" : "",
                            "subComments" : {
                                "commentedBy" : "jaril",
                                "date" : "",
                                "comment" : "Hello world inside dark"
                            }
                        }, 
                        {
                            "commentId" : "3",
                            "commentedBy" : "test",
                            "date" : "",
                            "comment" : "Hello world",
                            "attachements" : [ 
                               "1",
                               "raj"
                            ],
                            "emojis" : [ 
                                ":smile:", 
                                ":thumbsup:"
                            ],
                            "updatedBy" : "arkadata",
                            "updatedOn" : "",
                            "subComments" : {
                                "commentedBy" : "jaril",
                                "date" : "",
                                "comment" : "Hello world inside dark"
                            }
                        }, 
                        {
                            "commentId" : 6.0
                        }
                    ],
                    "dueDate" : "",
                    "createdDate" : "",
                    "lastUpdated" : "",
                    "checkList" : [],
                    "position" : "5",
                    "status" : "active"
                },
            "timestamp" : ISODate("2018-07-24T05:46:23.890Z")
        }

Answer 1

你可以试试 mongodb 3.6 arrayFilters

db.collection.update(
  { "_id": ObjectId(5b56bd2f3e18580edc85af73) },
  { "$push": { "Cards.$[card].comments.$[comment].attachments": "2" } },
  { "arrayFilters": { "card.cardID": ObjectId("5b56c895d0a04836f71aa776"), "comment.commentId": 2 } }
)

确保将您的 ID 转换为 ObjectId

编辑:

db.collection.update(
  { "_id": ObjectId(5b56bd2f3e18580edc85af73) },
  { "$push": { "Cards.$[card].comments.$[comment].attachments": "2" } },
  { "arrayFilters": [
    { "card.cardID": ObjectId("5b56c895d0a04836f71aa776")},
    {"comment.commentId": 2 }
    ]
  }
)