How to remove an nested array element from Array

Question

I want to remove an nested array element if its first value is 0 from array. The data is shown below.

[
  {
    "data": [[0,1],[2,3],[0,3],[4,5]]
  }
]

test case

And here is my solution, which doesn't work.

db.collection.update({},
{
  "$pull": {
    "data": {
      "$elemMatch": {
        "0": 0
      }
    }
  }
})

Tom Slabbaert · Accepted Answer · 2021-01-22 12:46:19Z

4

If you're using Mongo version 4.2+ you can use pipelined updates like so:

db.collection.update({},
[
  {
    $set: {
      data: {
        $filter: {
          input: "$data",
          as: "datum",
          cond: {
            $ne: [
              {
                $arrayElemAt: [
                  "$$datum",
                  0
                ]
              },
              0
            ]
          }
        }
      }
    }
  }
])

Mongo Playground

answered Jan 22, 2021 at 12:46

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

How to remove an nested array element from Array

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related