[{"organisationId":"","bcpId":"","bcpName":"","bcpDescription":"","biaEntity":{},"version":"0.01","status":"PENDING","primaryBridgeNumber":"1","alternateBridgeNumber":"2","scenario":[{"_id":{"$oid":"5e3ab709367d2c5f5826c6fd"},"scenario":"","strategies":[{"mdmStrategy":{},"strategy":{"pSIStrategyDetails":{"scenarioName":"","strategyName":"","rto":"","sustainablePeriod":{},"description":"1","primaryContact":{},"secondaryContact":{},"recoverySite":{}},"pSICriticalStaff":{},"specialRequirement":[{},{},{},{},{}]},"createdOn":{},"updatedOn":{}},{"mdmStrategy":{},"strategy":{"pSIStrategyDetails":{},"pSICriticalStaff":{},"specialRequirement":[{},{},{},{},{}]},"createdOn":{},"updatedOn":{}}],"description":"","status":"Active","createdOn":{},"updatedOn":{}}],"updatedOn":{},"createdOn":{},"business_owner_id":{},"bc_coordinator_id":{},"backup_business_owner_id":{},"backup_business_coordinator_id":{},"sme_id":{},"_class":"com.bcm.bcp.api.model.BcmBcpEntity"}]

db.collection.aggregate([{$unwind:"$scenario"},{$unwind:"$scenario.strategies"},{$project:{bcpId:1,bcpName:1,bcpDescription:1,version:1,status:1,scenario:{scenario:1,strategies:{strategy:{pSIStrategyDetails:{rto:1,strategyName:1}}}}}}])