Database
[{"scenarioName":"test scenario","outputs":{"allocation":[{"name":"Loan USA","allocatedAmount":[{"fund":"INFLOW","usdAmount":80000000,},{"fund":"STACK_MONEY","usdAmount":50000000,},{"fund":"ABK3T","usdAmount":150000000,}]}]},"lastUpdateDate":{"$date":"2020-06-24T04:00:00.000Z"},"lastUpdatedBy":"michealJackson"}]
Query
db.collection.aggregate([{$match:{"outputs.allocation.allocatedAmount.fund":{$in:["CASH_SHEET","STACK_MONEY","BALANCE_SHEET"]}}}])