======================= SO Shipment New, ==================== ================================================================ ~/eWms/soShipmentByPlan/list/ => db.EvolveSalesOrderShipment.aggregate([ { "$match": {} }, { "$lookup": { "from": "EvolveCustomer", "localField": "EvolveCustomer_ID", "foreignField": "_id", "as": "EvolveCustomer_ID" } }, { "$unwind": { "path": "$EvolveCustomer_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveAddress", "localField": "EvolveBillTo_ID", "foreignField": "_id", "as": "EvolveBillTo_ID" } }, { "$unwind": { "path": "$EvolveBillTo_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveAddress", "localField": "EvolveShipTo_ID", "foreignField": "_id", "as": "EvolveShipTo_ID" } }, { "$unwind": { "path": "$EvolveShipTo_ID", "preserveNullAndEmptyArrays": true } }, { "$addFields": { "User": { "$cond": [ { "$eq": [ { "$type": "$updatedUser" }, "missing" ] }, "$createdUser", "$updatedUser" ] } } }, { "$lookup": { "from": "EvolveUser", "let": { "user": "$User" }, "pipeline": [ { "$match": { "$expr": { "$eq": [ "$_id", "$$user" ] } } } ], "as": "EvolveUser" } }, { "$unwind": { "path": "$EvolveUser", "preserveNullAndEmptyArrays": true } }, { "$addFields": { "userName": "$EvolveUser.EvolveUser_Name" } }, { "$addFields": { "Date": { "$cond": [ { "$eq": [ { "$type": "$updatedAt" }, "missing" ] }, "$createdAt", "$updatedAt" ] } } }, { "$addFields": { "updateDate": "$Date" } }, { "$addFields": {} }, { "$match": { "$and": [ { "$or": [ { "$expr": { "$eq": [ "$EvolveUnit_ID", { "$toObjectId": "62de23659b90475655e4df50" } ] } } ] } ] } }, { "$sort": { "_id": -1 } }, { "$skip": 0 }, { "$limit": 10 } ]) -------------------- End ---------------------------------------