========    Integration Master    ===============

========    "~/mdm/integration/list/  ===============

 // populate

1.   db.EvolveIntegration.aggregate ([ 
   {
    '$lookup': {
      from: 'EvolveUnit',
      localField: 'EvolveUnit_ID',
      foreignField: '_id',
      as: 'EvolveUnit_ID'
    }
  },
  {
    '$unwind': { path: '$EvolveUnit_ID', preserveNullAndEmptyArrays: true }
  },
   {
    '$lookup': {
      from: 'EvolveCompany',
      localField: 'EvolveCompany_ID',
      foreignField: '_id',
      as: 'EvolveCompany_ID'
    }
  },
  {
    '$unwind': { path: '$EvolveCompany_ID', preserveNullAndEmptyArrays: true }
  },
   {
    '$lookup': {
      from: 'EvolveBusinessGroup',
      localField: 'EvolveBusinessGroup_ID',
      foreignField: '_id',
      as: 'EvolveBusinessGroup_ID'
    }
  },
  {
    '$unwind': {
      path: '$EvolveBusinessGroup_ID',
      preserveNullAndEmptyArrays: true
    }
  },
  { '$sort': { _id: -1 } },
  { '$match': { } },
])

2.     db.EvolveIntegration.find({})


========================================================