how to delete a specific object from array object in MongoDB

Question

mycode is look like below:-

{
  "_id" : ObjectId("52a02251305157fe20ce140f"),
  "cats" : [
          {
                  "catname" : "elect",
                  "disname" : "Elect",
                  "subcats" : [
                          {
                                  "subcatname" : "mobile",
                                  "subdisname" : "Mobiles"
                          },
                          {
                                  "subcatname" : "cam",
                                  "subdisname" : "Cam"
                          }
                  ]
          }
  ]
  }

I Want To Delete mobile from subcats i am trying like below:-

 db.demo.update({"cats.catname":"elect"},{$pull: {"subcats.$.subcatname":"mobile"}},  {"upsert":true})

After Delete mobile code look like below(i Expected like below):-

 {
  "_id" : ObjectId("52a02251305157fe20ce140f"),
  "cats" : [
          {
                  "catname" : "elect",
                  "disname" : "Elect",
                  "subcats" : [
                          {
                                  "subcatname" : "cam",
                                  "subdisname" : "Cam"
                          }
                  ]
          }
    ]
    }

Best Regards GSY

Parvin Gasimzade · Accepted Answer · 2013-12-05 08:09:14Z

1

You can remove it by using $pull operator. Query should be as follows :

db.myObject.update(
    {"cats.catname" : "elect"},
    {$pull:{"cats.$.subcats" : {subcatname : "mobile"}}}
);

edited Dec 5, 2013 at 8:09

answered Dec 5, 2013 at 8:01

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

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

Comments

Andrew · Accepted Answer · 2013-12-05 08:07:39Z

0

Not

{$pull: {"subcats.$.subcatname":"mobile"}}

but

{$pull: {"cats.$.subcats":{"subcatname":"mobile"}}

>

db.demo.update({"cats.catname":"elect"},{$pull: {"cats.$.subcats":{"subcatname":"mobile"}}})

answered Dec 5, 2013 at 8:07

Andrew

5,3601 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

how to delete a specific object from array object in MongoDB

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related