Database
[{"tenantId":"MY_TENANT_ID","status":"WAITING_FOR_APPROVAL"},{"tenantId":"MY_TENANT_ID","status":"APPROVED"},{"tenantId":"MY_TENANT_ID","status":"SENT"},{"tenantId":"MY_TENANT_ID","status":"OTHER_STATUS"},{"tenantId":"MY_TENANT_ID","status":"OTHER_FINAL_STATUS"},{"tenantId":"MY_OTHER_TENANT","status":"WAITING_FOR_APPROVAL"},{"tenantId":"MY_OTHER_TENANT","status":"OTHER_STATUS"}]
Query
db.collection.aggregate([{$match:{tenantId:"MY_TENANT_ID",status:{$nin:["WAITING_FOR_APPROVAL","APPROVED","SENT"]}}}])