MongoDB中

Question

我的收藏结构

{ 
     "companyName": "iAssure", 
     "companyDepartment": [ 
      { 
       "Department": "IT", 
       "companysubDepartment": [ 
        "HR", 
        "Finance", 
        "Account" 
       ] 
      }, 
      { 
       "Department": "Production", 
       "companysubDepartment": [ 
        "Raw Material", 
        "Quality" 
       ] 
      } 
     ] 
    } 

我想从companysubDepartment删除HR其中部是IT

Answer 1

你错过了更新$ operator对象的数组中删除数组中的元素。

检查以下查询：

db.companySettings.update({'_id':"9uvjCujcjSbbLYi86","companyDepartment": 
          {"$elemMatch":{"Department":"IT"}}}, 
          {"$pull":{"companyDepartment.$.companysubDepartment":"HR"}})