======================= Purchase Order Receiving, ==================== ================================================================ ~/eWms/purchaseOrderRecieve_MT/list/ => db.EvolvePoRecieve.aggregate([ { "$match": {} }, { "$lookup": { "from": "EvolveSupplier", "localField": "EvolveSupplier_ID", "foreignField": "_id", "as": "EvolveSupplier_ID" } }, { "$unwind": { "path": "$EvolveSupplier_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveGate", "localField": "EvolveGate_ID", "foreignField": "_id", "as": "EvolveGate_ID" } }, { "$unwind": { "path": "$EvolveGate_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": {} }, { "$match": {} }, { "$sort": { "_id": -1 } }, { "$skip": 0 }, { "$limit": 10 } ]) -------------------- End ---------------------------------------