======================= DO List, ==================== ================================================================ ~/eWms/distributionOrder/list/ $$$$ => db.EvolveDO.aggregate([ { "$lookup": { "from": "EvolveUnit", "localField": "EvolveDO_ShipFrom", "foreignField": "_id", "as": "EvolveDO_ShipFrom" } }, { "$unwind": { "path": "$EvolveDO_ShipFrom", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveAddress", "localField": "EvolveDO_ShipFrom.EvolveAddress_ID", "foreignField": "_id", "as": "EvolveDO_ShipFrom.EvolveAddress_ID" } }, { "$unwind": { "path": "$EvolveDO_ShipFrom.EvolveAddress_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveUnit", "localField": "EvolveDO_ShipTo", "foreignField": "_id", "as": "EvolveDO_ShipTo" } }, { "$unwind": { "path": "$EvolveDO_ShipTo", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveAddress", "localField": "EvolveDO_ShipTo.EvolveAddress_ID", "foreignField": "_id", "as": "EvolveDO_ShipTo.EvolveAddress_ID" } }, { "$unwind": { "path": "$EvolveDO_ShipTo.EvolveAddress_ID", "preserveNullAndEmptyArrays": true } }, { "$addFields": { "shipFrom": "$EvolveDO_ShipFrom.EvolveUnit_Code", "shipTo": "$EvolveDO_ShipTo.EvolveUnit_Code", "EvolveDO_CreatedDate": { "$dateToString": { "format": "%d-%m-%Y", "date": "$EvolveDO_CreatedDate" } }, "EvolveDO_ShipDate": { "$dateToString": { "format": "%d-%m-%Y", "date": "$EvolveDO_ShipDate" } }, "EvolveDO_DueDate": { "$dateToString": { "format": "%d-%m-%Y", "date": "$EvolveDO_DueDate" } } } }, { "$match": { "$or": [ { "EvolveDO_ShipFrom.EvolveUnit_Code": "CFD01" }, { "EvolveDO_ShipTo.EvolveUnit_Code": "CFD01" } ] } }, { "$match": {} }, { "$sort": { "_id": -1 } }, { "$skip": 0 }, { "$limit": 10 } ]) -------------------- End ---------------------------------------