I need to remove all entries in the infrastructure collection with a type.primary of "pipelines" and a type.secondary of "oil."
Currently, I'm using this query:
db.infrastructure.deleteMany({$and: [{"properties.type.primary": "pipelines"}, {"properties.type.secondary": "oil"}] })However, the result is:
{ acknowledged: true, deletedCount: 0 }This is puzzling because MongoDB Compass shows that there are 182 matching documents for the query
{$and: [{"properties.type.primary": "pipelines"}, {"properties.type.secondary": "oil"}] }The structure of my documents looks like this:
properties": {
"optional": {
"description": ""
},
"original": {
"Opername": "ENBRIDGE",
"Pipename": "Lakehead",
"Shape_Leng": 604328.294581,
"Source": "EIA"
},
"required": {
"unit": null,
"viz_dim": null,
"years": []
},
"type": {
"primary": "pipelines",
"secondary": "oil"
}
...
According to my understanding, I should just be passing a filter to deleteMany(), where $and expects an array of objects. It's strange that the combination isn't working as expected here.