Remove entire objects by array of ids

Question

I have an array of objects that contains metadata and looks similar to this.

Data:

metadata:[ 
  { matchid: '1', region: 'europe' }, 
  { matchid: '2', region: 'africa' },
  { matchid: '3', region: 'asia' },
]

I have an endpoint setup to receive an array of IDS ['1', '2'] which would the remove all the objects containing these IDS.

This is my current query:

Query to remove objects

xx.findByIdAndUpdate(
    id,
    $pullAll: {
        "metadata.matchid": {
           $in: req.body.matches
        }
    }
)

I am expecting both objects with the ids of 1 and 2 to be removed

Expected Results:

metadata:[ 
  { matchid: '3', region: 'asia' },
]

I am recieving an error I have never seen before it is an object that says codeName: "BadValue"

$pullAll removes only the elements in the array that match the specified value exactly you given, including order. And it starts with an empty operand expression ( { } ) . So, maybe query like this: xx.findByIdAndUpdate(id, { $pullAll: { "metadata.matchid": [{ $in: req.body.matches }], }, });. — Golamrabbi Azad
– Golamrabbi Azad, Commented Aug 9, 2021 at 20:25

J.F. · Accepted Answer · 2021-08-09 20:39:09Z

1

As documentation says:

The $pullAll operator removes all instances of the specified values from an existing array. Unlike the $pull operator that removes elements by specifying a query.

$pullAll requires and exact match and $pull is like to use a filter. So you can use $pull in this way.

yourModel.findByIdAndUpdate(
    id,
    $pull: {
        metadata:{
           matchid: { $in: req.body.matches}
        }
    }
)

Example here

answered Aug 9, 2021 at 20:39

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Remove entire objects by array of ids

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