Pull Document By ID from Triple Nested Array MongoDB

Question

I'd like to be able to pull a document by id from a triple nested array of documents. DB looks something like this:

[{
    type: "Foods",
    fruit: [{
      name: "Apple",
      kinds: [{
        name: "Red Delicious"
        details: [{
           _id: ObjectId("123123123"),
           colors: ["red", "yellow"]
           }]
        }]
    }]
}]

I'd like to be able to pull the document with the _id: 123123123. I've tried many different ways, but it always says it matches, but won't modify the document.

I've tried:

db.stuff.update({}, {$pull: {fruits: {kinds: {details: {_id: "123123123"}}}}}), 
db.stuff.update({}, {$pull: {"fruits.kinds.details' : {_id: "123123123"}}}),
db.stuff.update({}, {$pull: {"fruits.$[].kinds.$[].details' : {_id: "123123123"}}})

But everytime it matches, but won't delete the document. Please help.

mickl · Accepted Answer · 2020-08-04 20:55:23Z

1

The last attempt is correct however you need to fix two things: fruit instead of fruit (according to your sample data) and types needs to match so you have to convert string to ObjectId

db.stuff.update({}, {$pull: {"fruit.$[].kinds.$[].details' : {_id: mongoose.Types.ObjectId("123123123")}}})

answered Aug 4, 2020 at 20:55

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Pull Document By ID from Triple Nested Array 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