db={products:[{"_id":123345,"name":"NutraFast","description":"Supplement","price":35.99},{"_id":13443,"name":"BerryBlast","description":"Athletes Sports Drink","price":12.99},{"_id":15644,"name":"MagnoPower-11","description":"Supplement","price":45.99},{"_id":17011,"name":"Zinc566","description":"Supplement","price":25.99},{"_id":15011,"name":"VitaMax","description":"Supplement","price":15.99},{"_id":15311,"name":"VitaMax","description":"Supplement","price":15.99},{"_id":15316,"name":"Chlorphyl Cleanse","description":"Supplement","price":55.99}],productDetail:[{"_id":123345,"discount":0.3,"amount-per-unit":50,"inStock":"Y"},{"_id":13443,"discount":0.5,"onSale":"Y","amount-per-unit":60,"inStock":"Y"},{"_id":15644,"discount":0.5,"onSale":"Y","amount-per-unit":60,"inStock":"Y"},{"_id":15011,"discount":0.5,"amount-per-unit":60,"inStock":"Y"},{"_id":17011,"discount":0.5,"amount-per-unit":60,"inStock":"Y"}]}

db.products.aggregate([{$lookup:{from:"productDetail",localField:"_id",foreignField:"_id",as:"productDetail"}},{$unwind:{path:"$productDetail",preserveNullAndEmptyArrays:true}},{$set:{inProductDetailCollectionButNotOnSale:{$cond:[{$and:[{$gt:["$productDetail",0]},{$ne:["$productDetail.onSale","Y"]}]},true,false]}}}])