Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
None
-
None
-
Query Optimization
-
Query 2019-11-04
Description
Consider following document:
{
|
items: [
|
[1, [2]], |
[2, [1]], |
[3, [1]], |
[2, [1]], |
]
|
}
|
|
I want to remove all items which their 0 index is 2.
db.col.updateMany(
|
{},
|
{
|
$pull: {
|
'items': { |
0: 2 |
}
|
}
|
}
|
)
|
this does nothing.
db.col.update(
|
{},
|
{
|
$pull: {
|
'items': { |
$elemMatch: {
|
'0': 2 |
}
|
}
|
}
|
}
|
)
|
this oddly removes first item of items.
db.col.updateMany(
|
{},
|
{
|
$pull: {
|
'items': { |
$elemMatch: {
|
$in: [2] |
}
|
}
|
}
|
}
|
)
|
this works as expected.