Database
[{"_id":ObjectId("648031bd784fbf6081de41cf"),"orgId":1,"applications":{"_id":ObjectId("6479ddda073ced427d04e9dd"),"orgId":1,"firstTimeInstalled":[{"refId":ObjectId("648031bd784fbf6081de41cf"),"installDate":"2023-06-08T09:18:49.233+00:00"},{"refId":ObjectId("6479ddda073ced427d04e9dd"),"installDate":"2023-06-08T09:18:49.233+00:00"}]}},{"_id":ObjectId("648031bd784fbf6081de41cd"),"orgId":1,"applications":{"_id":ObjectId("6479ddda073ced427d04e9dd"),"orgId":1,"firstTimeInstalled":[{"refId":ObjectId("648031bd784fbf6081de41cf"),"installDate":"2023-06-08T09:18:49.233+00:00"},{"refId":ObjectId("6479ddda073ced427d04e9dd"),"installDate":"2023-06-08T09:18:49.233+00:00"}]}}]
Query
db.collection.aggregate([{$match:{$expr:{$not:{$anyElementTrue:{$map:{input:"$applications.firstTimeInstalled",in:{$eq:["$$this.refId","$_id"]}}}}}}}])