Database
db={Offices:[{_id:"d0ca792b-6ab3-464c-92ec-241be5551405",Name:"Office1",Status:"Active"},{_id:"1e49c08b-dfdb-4b29-aa01-63f32086647d",Name:"Office2",Status:"Inactive"},{_id:"d20d002f-a343-478b-9910-ceb2ee5d9fd3",Name:"Office3",Status:"Active"}],Customers:[{_id:"10734c4f-c7c9-4db0-8bc6-2077cb85c242",Status:0,OfficeId:"d0ca792b-6ab3-464c-92ec-241be5551405"},{_id:"557fe764-c345-4fd7-94fa-086ce9e95415",Status:0,OfficeId:"d20d002f-a343-478b-9910-ceb2ee5d9fd3"},{_id:"b8998295-700b-451e-aff9-8c2a61ee25d3",Status:0,OfficeId:"d0ca792b-6ab3-464c-92ec-241be5551405"},{_id:"f90bce6d-a35d-4733-8d53-3085b15412d7",Status:1,OfficeId:"d20d002f-a343-478b-9910-ceb2ee5d9fd3"},{_id:"3023ad50-6dde-4c1b-b695-c75a147481e1",Status:0,OfficeId:"d0ca792b-6ab3-464c-92ec-241be5551405"},{_id:"74c46c51-6738-4eb8-ba47-a494189db5b4",Status:1,OfficeId:"d20d002f-a343-478b-9910-ceb2ee5d9fd3"},{_id:"447542b4-bf34-4a74-8168-c068248ae703",Status:1,OfficeId:"1e49c08b-dfdb-4b29-aa01-63f32086647d"},{_id:"aa461e7b-5a40-4e74-91f0-82c8df9c6106",Status:0,OfficeId:"d20d002f-a343-478b-9910-ceb2ee5d9fd3"},{_id:"06d224f1-fc7f-4395-934b-41f53bf6439b",Status:1,OfficeId:"1e49c08b-dfdb-4b29-aa01-63f32086647d"},{_id:"6bf2b36d-3470-4d1a-a50e-70b693b02ea5",Status:0,OfficeId:"d20d002f-a343-478b-9910-ceb2ee5d9fd3"}]}
Query
db.Customers.aggregate([{"$lookup":{"from":"Offices","localField":"OfficeId","foreignField":"_id","as":"office"}},{$match:{"office.Status":"Active"}},{$unset:"office"}])