======================= Supplier Master, ==================== ================================================================ ~/mdm/SupplierMaster/list/ => db.EvolveSupplier.aggregate([ { "$lookup": { "from": "EvolveAddress", "localField": "EvolveBillTo_ID", "foreignField": "_id", "as": "EvolveBillTo_ID", } }, { $unwind: { path: "$EvolveBillTo_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveCurrency", "localField": "EvolveSupplierAcountingDetails.EvolveCurrency_ID", "foreignField": "_id", "as": "EvolveSupplierAcountingDetails.EvolveCurrency_ID", } }, { $unwind: { path: "$EvolveSupplierAcountingDetails.EvolveCurrency_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveCreditTerm", "localField": "EvolveSupplierAcountingDetails.EvolveCreditTerms_ID", "foreignField": "_id", "as": "EvolveSupplierAcountingDetails.EvolveCreditTerms_ID", } }, { $unwind: { path: "$EvolveSupplierAcountingDetails.EvolveCreditTerms_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveSerial", "localField": "EvolveSupplierOperationDetails.EvolveSupplier_DayBookSet", "foreignField": "_id", "as": "EvolveSupplierOperationDetails.EvolveSupplier_DayBookSet", } }, { $unwind: { path: "$EvolveSupplierOperationDetails.EvolveSupplier_DayBookSet", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveLanguage", "localField": "EvolveSupplierOperationDetails.EvolveLanguage_ID", "foreignField": "_id", "as": "EvolveSupplierOperationDetails.EvolveLanguage_ID", } }, { $unwind: { path: "$EvolveSupplierOperationDetails.EvolveLanguage_ID", preserveNullAndEmptyArrays: true } }, { $sort: { _id: -1 } }, ] ) -------------------- End ---------------------------------------