========================================================== ======== Bill Of Entry Master =============== ======== ~/mdm/advanceLicenseModule/billOfEntry/list/ =============== //// populate db.EvolveBillOfEntry.aggregate([ { "$lookup": { "from": "EvolveSupplier", "localField": "EvolveSupplier_ID", "foreignField": "_id", "as": "EvolveSupplier_ID" } }, { "$unwind": { "path": "$EvolveSupplier_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveLicense", "localField": "EvolveBillOfEntryDetail.EvolveLicense_ID", "foreignField": "_id", "as": "EvolveBillOfEntryDetail.EvolveLicense_ID" } }, { "$unwind": { "path": "$EvolveBillOfEntryDetail.EvolveLicense_ID", "preserveNullAndEmptyArrays": true } }, { "$lookup": { "from": "EvolveLicenseItemGroup", "localField": "EvolveBillOfEntryDetail.EvolveLicenseItemGroup_ID", "foreignField": "_id", "as": "EvolveBillOfEntryDetail.EvolveLicenseItemGroup_ID" } }, { "$unwind": { "path": "$EvolveBillOfEntryDetail.EvolveLicenseItemGroup_ID", "preserveNullAndEmptyArrays": true } }, {"$match":{} } ]) ///// no collection in database ========================================================