Database

[{"apiCallCount":1,"_id":"5e0da052b4b3fe5188602e11","email":"abc@def.net","password":"123123","userName":"username","companyName":"companyName","apiKey":"apiKey","solutionType":"solutionType","parentCompany":"parentCompany","buildings":[{"gateways":[{"devices":[{"_id":"5e0da052b4b3fe5188602e15","serialNumber":"serialNumber 1","area":"area","connectionStatus":0,"gatewayKey":"gatewayKey","applicationNumber":11,"firmwareVersion":"firmwareVersion","needsAttention":true,"verificationCode":"123456","patientRiskStatus":"patientRiskStatus","patientFirstName":"UPDATED!!!","patientLastName":"patientLastName","createdAt":"2020-01-02T07:48:34.287Z","updatedAt":"2020-01-02T07:48:34.287Z"},{"_id":"5e0da052b4b3fe5188602e14","serialNumber":"serialNumber 2","area":"area","connectionStatus":0,"gatewayKey":"gatewayKey","applicationNumber":22,"firmwareVersion":"firmwareVersion","needsAttention":true,"verificationCode":"987654","patientRiskStatus":"patientRiskStatus","patientFirstName":"patientFirstName","patientLastName":"patientLastName","createdAt":"2020-01-02T07:48:34.288Z","updatedAt":"2020-01-02T07:48:34.288Z"}],"_id":"5e0da052b4b3fe5188602e13","gatewayName":"gatewayName 1","gatewayKey":"gatewayKey","suite":"suite","createdAt":"2020-01-02T07:48:34.288Z","updatedAt":"2020-01-02T07:48:34.288Z"}],"_id":"5e0da052b4b3fe5188602e12","buildingName":"buildingName 1","address":"address","suite":"suite","floor":"floor","timeZone":"String","createdAt":"2020-01-02T07:48:34.288Z","updatedAt":"2020-01-02T07:48:34.288Z"}],"createdAt":"2020-01-02T07:48:34.289Z","updatedAt":"2020-01-02T09:10:25.200Z","__v":0}]

Query

db.collection.aggregate([{$unwind:"$buildings"},{$unwind:"$buildings.gateways"},{$unwind:"$buildings.gateways.devices"},{$match:{"buildings._id":"5e0da052b4b3fe5188602e12","buildings.gateways._id":"5e0da052b4b3fe5188602e13","buildings.gateways.devices.verificationCode":"123456"}}])

Result