Delete an array containing Objects MongoDB

Question

I'm working in a project oj NodeJS, and I want to delete an element of array containing objets.

The Schema is:

{
  "products" : [
    {
      "productid" : 1,
      "name" : "product 1",
      "price" : 200
      
    },
    {
      "productid" : 2,
      "name" : "product 2",
      "price" : 300
      
    },
    {
      "productid" : 3,
      "name" : "product 3",
      "price" : 350
      
    },
    {
      "productid" : 4,
      "name" : "product 4",
      "price" : 300
      
    },
,
    {
      "productid" : 5,
      "name" : "product 5",
      "price" : 300
      
    }
    
  ]
}

And i want to delete product 3, how is query in mongodb? the "productid" attribute is key, does not repeat it

Thanks.

skmahawar · Accepted Answer · 2015-12-08 07:05:13Z

1

Use this:

Change collection name and {} as per your need.

db.collection.update( {}, { "$pull" : { "products" : { "productid" : 3 } } });

if it matches multiple element then use multi option like

db.collection.update( {}, { "$pull" : { "products" : { "productid" : 3 } } }, 
{ multi: true });

edited Dec 8, 2015 at 7:05

skmahawar

3111 silver badge13 bronze badges

answered Dec 8, 2015 at 4:58

Hiren S.

2,82017 silver badges25 bronze badges

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

Comments

Soni Pandey · Accepted Answer · 2015-12-08 08:48:13Z

0

db.collection.update( {<query>}, { "$pull" : { "products.productid" : 3  } });

answered Dec 8, 2015 at 8:48

Soni Pandey

5145 silver badges16 bronze badges

Collectives™ on Stack Overflow

Delete an array containing Objects MongoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related