======================= Rejection Report, ====================
================================================================
 ~/eSmartFactory/DepartmentWiseReject_Report/list/
 => 
 db.EvolveOperationalActivity.aggregate([{"$match":{"$and":[{"EvolveUnit_Code":"CFD01"},{"EvolveOperationalActivity_ScrapQty":{"$gt":0}},{"EvolveWorkOrder_OrderID":"930"}]}},{"$lookup":{"from":"EvolveWorkOrder","let":{"wono":"$EvolveWorkOrder_OrderID"},"pipeline":[{"$match":{"$expr":{"$eq":["$EvolveWorkOrder_OrderID","$$wono"]}}},{"$project":{"_id":1,"EvolveWorkOrder_OrderID":1,"EvolveWorkOrder_OrderNo":1,"EvolveItem_ID":1,"EvolveMachine_ID":1,"EvolveUom_ID":1}}],"as":"EvolveWorkOrder_OrderID"}},{"$unwind":{"path":"$EvolveWorkOrder_OrderID","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"EvolveItem","let":{"item":"$EvolveWorkOrder_OrderID.EvolveItem_ID"},"pipeline":[{"$match":{"$expr":{"$eq":["$_id","$$item"]}}},{"$project":{"_id":1,"EvolveItem_Code":1,"EvolveItem_Desc1":1,"EvolveItem_Desc2":1}}],"as":"EvolveWorkOrder_OrderID.EvolveItem_ID"}},{"$unwind":{"path":"$EvolveWorkOrder_OrderID.EvolveItem_ID","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"EvolveUom","let":{"id":"$EvolveWorkOrder_OrderID.EvolveUom_ID"},"pipeline":[{"$match":{"$expr":{"$eq":["$_id","$$id"]}}}],"as":"EvolveWorkOrder_OrderID.EvolveUom_ID"}},{"$unwind":{"path":"$EvolveWorkOrder_OrderID.EvolveUom_ID","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"EvolveUser","let":{"id":"$createdUser"},"pipeline":[{"$match":{"$expr":{"$eq":["$_id","$$id"]}}},{"$project":{"EvolveUser_Name":1}}],"as":"createdUser"}},{"$unwind":{"path":"$createdUser","preserveNullAndEmptyArrays":true}},{"$addFields":{}},{"$match":{}},{"$skip":0},{"$limit":10},{"$sort":{"_id":-1}},{"$facet":{"result":[]}}])
 
 -------------------- End ---------------------------------------