[{_id:1,investmentParameters:{capitalAppreciationFrom:23,capitalAppreciationTo:57,rentalYieldFrom:23,rentalYieldTo:57,occupancyRateFrom:23,occupancyRateTo:57}},{_id:2,investmentParameters:{capitalAppreciationFrom:43,rentalYieldFrom:43,rentalYieldTo:78,occupancyRateFrom:43,occupancyRateTo:78}},{_id:3,investmentParameters:{capitalAppreciationTo:87,rentalYieldFrom:27,rentalYieldTo:87,occupancyRateFrom:27,occupancyRateTo:87}},{_id:4,investmentParameters:{capitalAppreciationFrom:17,capitalAppreciationTo:80,rentalYieldFrom:17,occupancyRateFrom:80,occupancyRateTo:80}},{_id:5,investmentParameters:{capitalAppreciationFrom:12,capitalAppreciationTo:15,rentalYieldTo:15,occupancyRateFrom:12,occupancyRateTo:15}},{_id:6,investmentParameters:{capitalAppreciationFrom:50,capitalAppreciationTo:80,rentalYieldFrom:50,rentalYieldTo:80,occupancyRateFrom:50}},{_id:7,investmentParameters:{capitalAppreciationFrom:30,capitalAppreciationTo:60,rentalYieldFrom:30,rentalYieldTo:60,occupancyRateTo:60}},{_id:8,investmentParameters:{capitalAppreciationFrom:70,capitalAppreciationTo:80}},{_id:9,investmentParameters:{rentalYieldFrom:80,rentalYieldTo:90}},{_id:10,investmentParameters:{occupancyRateFrom:75,occupancyRateTo:90}},{_id:11,investmentParameters:{capitalAppreciationFrom:12,rentalYieldFrom:12,occupancyRateFrom:12}},{_id:12,investmentParameters:{capitalAppreciationTo:11,rentalYieldTo:11,occupancyRateTo:11}},{_id:13,investmentParameters:{capitalAppreciationTo:1100,rentalYieldTo:11,occupancyRateTo:11}},{_id:14,investmentParameters:{capitalAppreciationFrom:1100,capitalAppreciationTo:1800,rentalYieldTo:11,occupancyRateTo:11}}]

db.collection.find({$and:[{$or:[{"investmentParameters.capitalAppreciationTo":{$lte:300}},{"investmentParameters.capitalAppreciationFrom":{$lte:300}},{"investmentParameters.capitalAppreciationTo":{$exists:true,$lte:300},"investmentParameters.capitalAppreciationFrom":{$exists:false}},{"investmentParameters.capitalAppreciationTo":{$gte:300},"investmentParameters.capitalAppreciationFrom":{$exists:false}}]}]})