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]]
}
]
And here is my solution, which doesn't work.
db.collection.update({},
{
"$pull": {
"data": {
"$elemMatch": {
"0": 0
}
}
}
})
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
]
}
}
}
}
}
])