MongoDB $pull from array with filter

Question

I have User collection:

[
  {
    _id: '5b3935c2d4850aa2d9f0ae25',
    feedBucket: [
      {
        _id: '2a3535c2d4852ba2d9f0ae52',
        createdAt: '2018-06-30 21:52:22.681'
      },
      {
        _id: '9f342c2d4852ba2d9f0ae52',
        createdAt: '2018-06-30 21:52:22.681'
      }
    ]
  },
  {
    _id: '3d2343c2d4850aa2d9f0ae33',
    feedBucket: [
      {
        _id: '2a3535c2d4852ba2d9f0ae52',
        createdAt: '2018-02-30 21:52:22.681'
      },
      {
        _id: '9f342c2d4852ba2d9f0ae52',
        createdAt: '2018-06-30 21:52:22.681'
      }
    ]
  }
]

And I am trying to pull document with id - '9f342c2d4852ba2d9f0ae52' from users feedBucket.

await User.updateMany(
  {},
  { $pull: { feedBucket: { _id: '9f342c2d4852ba2d9f0ae52' } } },
  { multi: true }
)

but it doesn't work, result is { n: 2, nModified: 0, ok: 1 }

Is this feedBucket._id a string or an ObjectId? If it's an ObjectID, then you'll have to change your modifier. — Radosław Miernik
– Radosław Miernik, Commented Jul 2, 2018 at 11:56
Yes it is an ObjectId, what do you mean 'then you'll have to change your modifier.'? — koasi
– koasi, Commented Jul 2, 2018 at 12:01

Ashh · Accepted Answer · 2018-07-02 12:12:12Z

2

If your feedBucket._id is ObjectId then you need to $pull it by converting to mongoose ObjectId

  const user = await User.update(
    { },
    { $pull: { feedBucket: { _id: mongoose.Types.ObjectId('5b07fa836569d356ba5bd2fa') } } },
    { multi: true }
  )

answered Jul 2, 2018 at 12:12

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

MongoDB $pull from array with filter

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