Database
[{"approvals":{"REV":"","SS":"","ABC":{"status":"Sent for approval","approved_at":"","approved_by":"",},"XYZ":{"status":"Approved","approved_by":"xxx@abc.com","approved_at":ISODate("2020-01-06T09:48:22.777Z")}}}]
Query
db.collection.find(
{
$expr:{
$anyElementTrue:{
$map:{
input:{
$objectToArray:"$approvals"
},
in:{
$ne:[
"$$this.v.status",
"Approved"
]
}
}
}
}
})