======================= SubCon Shipment, ====================
================================================================
 ~/eWms/subConShipmentByPO/list/
 $$$$
 => db.EvolveSubConShipment.aggregate([
  {
    "$lookup": {
      "from": "EvolveSupplier",
      "localField": "EvolveSupplier_ID",
      "foreignField": "_id",
      "as": "EvolveSupplier_ID"
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSupplier_ID",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$lookup": {
      "from": "EvolveAddress",
      "localField": "EvolveShipTo_ID",
      "foreignField": "_id",
      "as": "EvolveShipTo_ID"
    }
  },
  {
    "$unwind": {
      "path": "$EvolveShipTo_ID",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSubConShipment_Details",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$lookup": {
      "from": "EvolveWorkOrder",
      "localField": "EvolveSubConShipment_Details.EvolveWorkOrder_ID",
      "foreignField": "_id",
      "as": "EvolveSubConShipment_Details.EvolveWorkOrder_ID"
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSubConShipment_Details.EvolveWorkOrder_ID",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$lookup": {
      "from": "EvolveItem",
      "localField": "EvolveSubConShipment_Details.EvolveItem_ID",
      "foreignField": "_id",
      "as": "EvolveSubConShipment_Details.EvolveItem_ID"
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSubConShipment_Details.EvolveItem_ID",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$lookup": {
      "from": "EvolveLocation",
      "localField": "EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails.EvolveLocation_ID",
      "foreignField": "_id",
      "as": "EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails.EvolveLocation_ID"
    }
  },
  {
    "$unwind": {
      "path": "$EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails.EvolveLocation_ID",
      "preserveNullAndEmptyArrays": true
    }
  },
  {
    "$group": {
      "_id": "$EvolveSubConShipment_Details._id",
      "rootObj": {
        "$first": "$$ROOT"
      },
      "EvolveSubConShipment_LineDetails": {
        "$push": "$EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails"
      }
    }
  },
  {
    "$set": {
      "rootObj.EvolveSubConShipment_Details.EvolveSubConShipment_LineDetails": "$EvolveSubConShipment_LineDetails"
    }
  },
  {
    "$group": {
      "_id": "$rootObj._id",
      "rootObj": {
        "$first": "$rootObj"
      },
      "EvolveSubConShipment_Details": {
        "$push": "$rootObj.EvolveSubConShipment_Details"
      }
    }
  },
  {
    "$set": {
      "rootObj.EvolveSubConShipment_Details": "$EvolveSubConShipment_Details"
    }
  },
  {
    "$replaceRoot": {
      "newRoot": "$rootObj"
    }
  },
  {
    "$addFields": {}
  },
  {
    "$match": {}
  },
  {
    "$sort": {
      "_id": -1
    }
  },
  {
    "$skip": 0
  },
  {
    "$limit": 10
  }
])
 
 -------------------- End ---------------------------------------