How to delete deep array in mongodb?

Question

I am trying to delete "virtualNumber" : "12345" in the following document:

{
"_id" : ObjectId("50a9db5bdc7a04df06000005"),
"billingInfo" : null,
"date" : "dsfdsfsdfsd",
"description" : "sdfsdff",
"pbx" : {
  "_id" : ObjectId("50a9db5bdc7a04df06000006"),
  "did" : {
    "1234567890" : {
      "inventoryId" : "509df7547e84b25e18000001",
      "didcountry" : "india",
      "didState" : "bangalore",
      "routeType" : "CallForward",
      "didNumber" : "1234567890",
      "didVirtualNumbers" : [
        {
          "virtualNumber" : "12345"
        },
        {
          "virtualNumber" : "56789"
        }
      ],
      "id" : ObjectId("50a9db9acdfb4f9217000002")
    }
  },
},

I am using node.js, so I constructed a query in JavaScript:

var query = {_id: ObjectId("50a9db5bdc7a04df06000005")};

var obj = {};
obj["pbx.did.1234567890.didVirtualNumbers.virtualNumber"]=12345;
//problem
collection.update(query,{$pull:obj});

Lauri · Accepted Answer · 2012-11-19 07:47:30Z

2

You need to match the array element like:

{"$pull": {"pbx.did.7259591220.didVirtualNumbers": {"virtualNumber": "12345"}}}

So you should change your code to:

obj["pbx.did.7259591220.didVirtualNumbers"]={"virtualNumber": "12345"};

answered Nov 19, 2012 at 7:47

Lauri

4,8502 gold badges26 silver badges17 bronze badges

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

5 Comments

gauti Over a year ago

thanks but its not working, query is { '$pull': { 'pbx.did.7259591220.didVirtualNumbers': { virtualNumber: '12345' } } }

Lauri Over a year ago

When I save the document in your question into "objects" collection in my db, I can remove the virtualNumber "12345" from the document using query

db.objects.update({"_id" : ObjectId("50a9db5bdc7a04df06000005")}, {"$pull": {"pbx.did.7259591220.didVirtualNumbers": {"virtualNumber": "12345"}}})

. After this query, the document contains only the other virtualNumber "56789".

Lauri Over a year ago

Are you trying to run this in the Mongo console or as part of you application? Do you get any error messages?

Lauri Over a year ago

You have your code inside a db.collection call, right? Have you double checked that you have collection names etc. right?

gauti Over a year ago

oh my god, spelling mistake in collection name..very sorry for troubling, thanks a lot it working fine...

Nilam Doctor · Accepted Answer · 2012-11-19 08:12:11Z

0

Please refer to http://www.mongodb.org/display/DOCS/Updating#Updating-%24pull

It mentions the pull field should be an array.

edited Nov 19, 2012 at 8:12

answered Nov 19, 2012 at 7:40

Nilam Doctor

4917 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to delete deep array in mongodb?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related