======================= QC Temp Config, ==================== ================================================================ ~/mdm/qcTemplateConfig/list/ $$$$ => db.EvolveQCTemplateConfig.aggregate( [ { "$lookup": { "from": "EvolveQCTemplete", "localField": "EvolveQCTemplate_ID", "foreignField": "_id", "as": "EvolveQCTemplate_ID", } }, { $unwind: { path: "$EvolveQCTemplate_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveItem", "localField": "EvolveItem_ID", "foreignField": "_id", "as": "EvolveItem_ID", } }, { $unwind: { path: "$EvolveItem_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveSupplier", "localField": "EvolveSupplier_ID", "foreignField": "_id", "as": "EvolveSupplier_ID", } }, { $unwind: { path: "$EvolveSupplier_ID", preserveNullAndEmptyArrays: true } }, { "$lookup": { "from": "EvolveCustomer", "localField": "EvolveCustomer_ID", "foreignField": "_id", "as": "EvolveCustomer_ID", } }, { $unwind: { path: "$EvolveCustomer_ID", preserveNullAndEmptyArrays: true } }, ] )