我正试图查询我的文档,它看起来像这样
"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"),
},....
}
这个
Approval
对象可以有多个子文档,如ABC、XYZ…等,我需要查询此“批准”是否有任何子文档
"status"
不在
APPROVED
状态