How to delete the field in the mongodb collection?

Question

I have a data collection in mongodb like below:

{
    { "_id" : ObjectId("1"), "name" : "ABC", "group" : [ObjectId("11"), ObjectId("12"), ObjectId("13")]}
    { "_id" : ObjectId("2"), "name" : "DEF", "group" : [ObjectId("21"), ObjectId("22"), ObjectId("23")]}
}

I want to delete ObjectId("11") in the group field in document ObjectId("1").

I tried the code below:

aId = "1" 
bId = "11"
db.collection.updateOne({ _id: ObjectId(aId) }, { $pull: { group: { _id: ObjectId(bId) } } })

But failed.

I have also tried:

aId = "1" 
bId = "11"
db.collection.updateOne({ _id: aId }, { $pull: { group: { _id: bId } } })

But still failed to delete it.

Anything wrong with my code?

The field group is just an array of Object Ids . Try `db.collection.updateOne({ _id: aId }, { $pull: { group: bId } })` — Mukul Dev, Dec 18 '18 at 04:24
Possible duplicate of [MongoDB $pull syntax](https://stackoverflow.com/questions/26165650/mongodb-pull-syntax) — Björn, Dec 18 '18 at 07:54
@MukulDev agreed. But it needs to be `ObjectId(bId)`, does it not? — Björn, Dec 18 '18 at 07:55

score 0 · Answer 1 · answered Dec 18 '18 at 05:53

Use $unset like this:

db.products.update(
{ sku: "unknown" },
{ $unset: { quantity: "", instock: "" } })

This code will remove the fields quantity and instock from the firstdocument in the products collection where the field sku has a value of unknown. For more info

How to delete the field in the mongodb collection?

1 Answers1