Remove all array element in mongodb which has id match in array

Question

I have an array of the id which I get from post request in nodejs. I want to remove all the elements in the orders array which match receive id array.

eg remove_id = ['60f1ab20891ced4818b5ea88','60f1ab20891ced4818b5ea87'] so I want to remove all elements from orders array whoose id match match remove_id array.

orderdetail = {
  _id: 60f1ab20891ced4818b5ea86,
  totalPrice: 400,
  orders: [
    {
      _id: 60f1ab20891ced4818b5ea87,
      quantity: 1,
      price: 200,
      name: 'Caramel Latte',
      category: 'Steaming Cups'
    },
    {
      _id: 60f1ab20891ced4818b5ea88,
      quantity: 1,
      price: 200,
      name: 'Cinnamon Latte',
      category: 'Steaming Cups'
    },
    {
      _id: 60f1ab20891ced4818b5ea89,
      quantity: 1,
      price: 200,
      name: 'Cinnamon Latte',
      category: 'Steaming Cups'
    }
  ],
  timestamp: 1626450720332,
  name: 'xxx',
  email: 'xxx',
}

what I have tried but not working,

Orderdetail.updateOne( { _id: '60f1ab20891ced4818b5ea86' }, { 
        $pull: { order: { _id: { $in: remove_id  } } } } )

Mayur Vaghasiya · Accepted Answer · 2022-01-11 06:23:03Z

4

Rename object name order to orders !

Try this code !

let remove_id = ['60f1ab20891ced4818b5ea87','60f1ab20891ced4818b5ea88']
db.getCollection('Orderdetail').updateOne({ _id: '60f1ab20891ced4818b5ea86' }, {
  $pull: {
    orders: { // rename this to orders 
      _id: { $in: remove_id }
    }
  }
})

answered Jan 11, 2022 at 6:23

Mayur Vaghasiya

1,4812 gold badges18 silver badges27 bronze badges

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

1 Comment

Alex Advent Over a year ago

sorry for such a smaller issue.

Collectives™ on Stack Overflow

Remove all array element in mongodb which has id match in array

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