Deleting specific record from an array nested within another array

Question

I have a MongoDB record as follow:

"id": 1,
"Tasks": [
    {
        "description": "BLAH",
        "Tags": [
            {
                "Name": "test",
                "tagID": "YRG+crq3SJucvlUwTo/uSg=="
            },
            {
                "Name": "Cars",
                "tagID": "ObwiiZpNTOGECgHb1HehHg=="
            }
        ]

    },
    ......
  ]

I'm trying to delete the object from 'Tags' with the 'Name: test' by reference to its 'tagID'. The query I have deletes the whole record within 'Tasks' not just that particular Tags object.

db.user.update({ 'id': 1 }, 
    { 
        '$pull': { 'Tasks': {'Tags.tagID': "YRG+crq3SJucvlUwTo/uSg==" }}
    },
    { '$multi': 'true' }
)

How can I ammend my query to only remove that particular tag and not remove the entire record?

chridam · Answer 1 · 2015-04-06T14:45:43.840

1

Use the positional operator $ together with the $pull update operator to remove the specific array element object:

db.user.update({"id": 1, "Tasks.description": "BLAH"},
   {
       "$pull": {"Tasks.$.Tags" : { "tagID": "YRG+crq3SJucvlUwTo/uSg==" }}
   },
   { multi: true}
);

edited Apr 06 '15 at 14:45

answered Apr 06 '15 at 14:18

chridam

100,957
23
236
235

1

I think it is `multi` not `$multi` – styvane Apr 06 '15 at 14:28
@Michael You are correct, thanks for the correction. – chridam Apr 06 '15 at 14:46

styvane · Accepted Answer · 2015-04-06T15:22:07.080

1

Using Pymongo and the $ operator

col.update({"id": 1, "Tasks.description": "BLAH"},
    {
           "$pull": {"Tasks.$.Tags" : { "tagID": "YRG+crq3SJucvlUwTo/uSg==" }}
    }, multi=True 
)

edited Apr 06 '15 at 15:22

answered Apr 06 '15 at 14:31

styvane

59,869
19
150
156

score 0 · Answer 3 · answered Apr 06 '15 at 13:51

0

I think you are looking for the $unset command. Reference here.

answered Apr 06 '15 at 13:51

Miguel A. Arilla

5,058
1
14
27

Deleting specific record from an array nested within another array

3 Answers3