-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Query 2019-11-04
-
None
-
None
-
None
-
None
-
None
-
None
-
None
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.