remove specific object from MongoDB collection

Question

I'm trying to remove from MongoDB collection an object (not document) that meets specific value condition, in this case - "Accessible" : "null" - while keeping other instances of this objects. I tried db.collection.update({}, {$unset: { "Accessible":"null"}}, false, true) but it removed all objects with "Accessible" key.Thanks in advance My MongoDB collection before update

{
"_id" : ObjectId("52e5f09e8f3d99e1046abccc"),
    "Name" : "Skyline",
"Accessible" : "Y"

}
{
"_id" : ObjectId("52e5f09e8f3d99e1046abccd"),
    "Name" : "Highland",
"Accessible" : "null"

}

Desired result:

{
"_id" : ObjectId("52e5f09e8f3d99e1046abccc"),
    "Name" : "Skyline",
"Accessible" : "Y"

}
{
"_id" : ObjectId("52e5f09e8f3d99e1046abccd"),
    "Name" : "Highland"

}

Jinxcat · Accepted Answer · 2014-01-29 20:54:55Z

1

You need to first identify the documents you wish to update and then unset that specific field:

db.collection.update(
    {"Accessible" : "null"}, 
    {$unset: { "Accessible" : ""}},
    { multi: true }
)

Further documentation on $unset operator: http://docs.mongodb.org/manual/reference/operator/update/unset/

answered Jan 29, 2014 at 20:54

Jinxcat

5841 gold badge3 silver badges17 bronze badges

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

1 Comment

Jinxcat Over a year ago

Please mark answer as correct, if you feel it was :)

Collectives™ on Stack Overflow

remove specific object from MongoDB collection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related