Removing complete document from array of documents in mongodb

Question

I m trying to completely remove a document from mongodb collection having an array of documents as property. I have used $pull and $unset , which successfully find and remove the values within a doc by making them null but the doc still exists.

Eg .Original document

{
    _id: 6452725 gsjhye73636,
    ItemsArray: [{
            _id: 757264 gsjfgs685,
            ItemName: "item1",
            ItemValue: "value1"
        },
        {
            _id: 757264 gsjfgs686,
            ItemName: "item2",
            ItemValue: "value2"
        },
        {
            _id: 757264 gsjfgs687,
            ItemName: "item3",
            ItemValue: "value3"
        }
    ],
    OtherProp: "some value"
}

After applying $pull and $unset for removing item2 document.

{
  _id: 6452725 gsjhye73636,
  ItemsArray: [{
          _id: 757264 gsjfgs685,
          ItemName: "item1",
          ItemValue: "value1"
      },
      {
          _id: 757264 gsjfgs686,
          ItemName: null,
          ItemValue: null
      },
      {
          _id: 757264 gsjfgs687,
          ItemName: "item3",
          ItemValue: "value3"
      }
  ],
  OtherProp: "some value"
}

What I want is this:

  {
  _id: 6452725 gsjhye73636,
  ItemsArray: [{
          _id: 757264 gsjfgs685,
          ItemName: "item1",
          ItemValue: "value1"
      },
      {
          _id: 757264 gsjfgs687,
          ItemName: "item3",
          ItemValue: "value3"
      }
  ],
  OtherProp: "some value"

}

Possible duplicate of [Using MongoDB $pull to delete documents within an Array](http://stackoverflow.com/questions/15121758/using-mongodb-pull-to-delete-documents-within-an-array) — s7vr, Apr 22 '17 at 17:47

score 0 · Answer 1 · answered Apr 22 '17 at 04:43

0

There is a very handy example at the end of the official documentation for $pull operator.

For your case, the query would be:

db.mycol.update({}, 
                {$pull: {"ItemsArray": {"ItemName": "item2"}}}
                )

answered Apr 22 '17 at 04:43

phreeLynx

65
3

But I just have the _id of item2 doc and not the actual values of item2. – Nikhil Apr 22 '17 at 05:26
Have you tried passing `_id` to the `$pull` operator ? – s7vr Apr 22 '17 at 17:45

Removing complete document from array of documents in mongodb

1 Answers1