mongodb $pull in array with another array

Question

Help me please to remove elements in an array with such document schema:

contracts: [
    {
      bandwidth: {
        calculated: {
          value: Number,
          documents: [id1, id2, id3, id4],
        }
      }
    }
  ]

I want to delete elements in all documents array that are in filter array.

I tried:

const documentsToDelete = [id2, id3]

const points = await Point.updateMany({
        $pull: {
            contracts: {"bandwidth.calculated.documents": {$in: documentsToDelete}}
        },
      });

But it does not work. The resulting array must contain "id1" and "id4"

turivishal · Accepted Answer · 2021-06-11 20:13:25Z

2

Correct the things,

the first parameter is the query part to match the condition
the contracts is an array so use $[] to update operation in all elements

const documentsToDelete = [id2, id3];
const points = await Point.updateMany(
  {},
  {
    $pull: {
      "contracts.$[].bandwidth.calculated.documents": {
        $in: documentsToDelete
      }
    }
  }
)

Playground

answered Jun 11, 2021 at 20:13

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Comments

Rafiq · Accepted Answer · 2022-11-11 16:42:23Z

-1

bellow quires worked for me well

let feed = await Feed.findOneAndUpdate(
      {
        _id: req.params.id,
        feeds: {
          $elemMatch: {
            type: FeedType.Post,
            locations: {
              $elemMatch: {
                uniqueName,
              },
            },
          },
        },
      },
      {
        $pull: {
          //@ts-ignore
          'feeds.$[].locations': { uniqueName },
        },
      },
      { new: true }
    );

or

let feed = await Feed.findOneAndUpdate(
      {
        $and: [
          {
            _id: req.params.id,
          },
          {
            'feeds.$[].locations': {
              $elemMatch: {
                uniqueName,
              },
            },
          },
        ],
      },
      {
        $pull: {
          //@ts-ignore
          'feeds.$[].locations': { uniqueName },
        },
      },
      { new: true }
    );

answered Nov 11, 2022 at 16:42

Rafiq

12k5 gold badges44 silver badges46 bronze badges

1 Comment

turivishal Over a year ago

Your answer is not related to the question, and also it looks like the wrong query, it can not support $[] in the query part.

Collectives™ on Stack Overflow

mongodb $pull in array with another array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related