Removing an array within an array in mongodb

Question

Within my mongo collection, I have a nested variable of called "institution.type". This is an array with the following elements:

db.collection.distinct("institution.type") 
[
null,
[
    "boarding"
],
"virtual"
]

I am trying to remove the entries with the "boarding" element, however am getting stuck due to the fact that boarding itself is within an array ( a mistake initially made when using "$push" to an array)

I have tried the following to find the documents:

db.collection.find({"institution.type":{ $in: ["boarding"]}}).count()
0

and

db.collection.update({"institution.id":"somenumber"}, {$pull:   {"institution.type.1":"boarding"}})
"type" : [
        "virtual",
        [ ]
         ]

How can I remove the brackets along with the "boarding" tag without getting the error of

JavaScript execution failed: SyntaxError: Unexpected identifier ?

Any advice would be greatly appreciated and welcomed!

TripWired · Accepted Answer · 2013-10-15 21:56:53Z

1

To find the item with the boarding subarray you have to use double brackets like so...

db.collection.find({"institution.type": {$in: [["boarding"]]}})

To pull the item out do the following:

db.collection.update({"institution.type": {$in: [["boarding"]]}}, {$pull: {"institution.type": ["boarding"]}})

answered Oct 15, 2013 at 21:56

TripWired

3787 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Removing an array within an array in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related