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 — s7vr
– s7vr, Commented Apr 22, 2017 at 17:47

phreeLynx · Accepted Answer · 2017-04-22 04:43:15Z

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, 2017 at 4:43

phreeLynx

753 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nikhil Over a year ago

But I just have the _id of item2 doc and not the actual values of item2.

s7vr Over a year ago

Have you tried passing _id to the $pull operator ?

Collectives™ on Stack Overflow

Removing complete document from array of documents in mongodb

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related