======================= QC Order PO gen, ==================== ================================================================ ~/eSmartFactory/qcOrder/list/PO => db.EvolveQCOrder.aggregate([ { "$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": "EvolveQCTemplete", "localField": "EvolveQCTemplete_ID", "foreignField": "_id", "as": "EvolveQCTemplete_ID", } }, { $unwind: { path: "$EvolveQCTemplete_ID", preserveNullAndEmptyArrays: true } }, { $match: {} }, ])