node.js - 如何在 MONGODB 的嵌套文档数组中 $pull 文档

Question

How to remove data from documents which have userId = "fadd66e5-97b9-4ae0-86ca-7922bf9d1da4" in parentHierarchy and have organizationId = "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de".

这是文档。

    [ {
        "name": "ABC", 
        "organization": [
           {
             "organizationId": "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de",
             "parentHierarchy": [
                {
                    "privelege": "Admin",
                    "userId": "fadd66e5-97b9-4ae0-86ca-7922bf9d1da4"
                },
                {
                    "privelege": "Manager",
                    "userId": "fadd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
              ]
            },
          {
            "organizationId": "d44a90c1-3f04-4dbd-97f0-cd1be3baf2de",
            "parentHierarchy": [
                {
                    "privelege": "Admin",
                    "userId": "fada66e5-97b9-4ae0-86ca-7922bf9d1da4"
                },
                {
                    "privelege": "Manager",
                    "userId": "fndd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
            ]
         }
       ]
    },
    {
        "name": "PQR", 
        "organization": [
           {
             "organizationId": "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de",
             "parentHierarchy": [
                {
                    "privelege": "Admin",
                    "userId": "fadd66e5-97b9-4ae0-86ca-7922bf9d1da4"
                },
                {
                    "privelege": "Manager",
                    "userId": "fadd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
              ]
            }
       ]
    }]

Output Document should be come in this format(which have no parenthierarchy in this organisationId "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de").

   [ {
        "name": "ABC", 
        "organization": [
           {
             "organizationId": "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de",
             "parentHierarchy": [
                {
                    "privelege": "Manager",
                    "userId": "fadd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
              ]
            },
          {
            "organizationId": "d44a90c1-3f04-4dbd-97f0-cd1be3baf2de",
            "parentHierarchy": [
                {
                    "privelege": "Admin",
                    "userId": "fada66e5-97b9-4ae0-86ca-7922bf9d1da4"
                },
                {
                    "privelege": "Manager",
                    "userId": "fndd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
            ]
         }
       ]
    },
    {
        "name": "PQR", 
        "organization": [
           {
             "organizationId": "d44a90c0-3f04-4dbd-97f0-cd1be3baf2de",
             "parentHierarchy": [
                {
                    "privelege": "Manager",
                    "userId": "fadd56e5-97b9-4ae0-86ca-7922bf9d1da4"
                }
              ]
            }
       ]
    }]

I have used query like this but not return proper data.

  var condition = {"organization.organizationId":condition.orgId,
            "organization.parentHierarchy.userId": userdata[0]._id}
  var update = {
       "$pull":{"organization":
                  {"organizationId": condition.orgId,
                   "parentHierarchy":{"userId": userdata[0]._id}}}
 }

 db.collection('users').update(condition, update, {multi: true}, 
    function(error, documents) {
    if(error){
        console.log("error in to update parentHierarchy");

    }
    else{
        console.log("updated Documents");

    }
})

Answer 1

Pull 运算符通过应用查询来工作，因为它是顶级文档，所以当条件找到文档时，它会删除 organization 嵌入数组中的文档。

您必须使用位置运算符来删除 parentHierarchy 嵌入式数组中的文档。

查询条件定位 organization 元素，后跟 $pull 以删除 parentHierarchy 文档数组中与 userid 匹配的所有文档。

var condition={"organization.organizationId":condition.orgId}
var update={"organization.$.parentHierarchy":{"userId": userdata[0]._id}}