======================= Mahindra SO Shipment, ====================
================================================================
 ~/eWms/salesOrderShipment_MT/list/
 => db.EvolveSalesOrderShipment.aggregate([
    {
      "$lookup": {
        "from": "EvolveCustomer",
        "localField": "EvolveCustomer_ID",
        "foreignField": "_id",
        "as": "EvolveCustomer_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveCustomer_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveAddress",
        "localField": "EvolveBillTo_ID",
        "foreignField": "_id",
        "as": "EvolveBillTo_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveBillTo_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveAddress",
        "localField": "EvolveShipTo_ID",
        "foreignField": "_id",
        "as": "EvolveShipTo_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveShipTo_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveSalesOrder",
        "localField": "EvolveSalesOrderShipment_Details.EvolveSalesOrder_ID",
        "foreignField": "_id",
        "as": "EvolveSalesOrderShipment_Details.EvolveSalesOrder_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveSalesOrder_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveItem",
        "localField": "EvolveSalesOrderShipment_Details.EvolveItem_ID",
        "foreignField": "_id",
        "as": "EvolveSalesOrderShipment_Details.EvolveItem_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveItem_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveUom",
        "localField": "EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveUom_ID",
        "foreignField": "_id",
        "as": "EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveUom_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveUom_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveHSN",
        "localField": "EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveItem_ShippingData.EvolveHSN_ID",
        "foreignField": "_id",
        "as": "EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveItem_ShippingData.EvolveHSN_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveItem_ID.EvolveItem_ShippingData.EvolveHSN_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveLocation",
        "localField": "EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails.EvolveLocation_ID",
        "foreignField": "_id",
        "as": "EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails.EvolveLocation_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails.EvolveLocation_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$group": {
        "_id": "$EvolveSalesOrderShipment_Details._id",
        "rootObj": {
          "$first": "$$ROOT"
        },
        "EvolveSalesOrderShipment_LineDetails": {
          "$push": "$EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails"
        }
      }
    },
    {
      "$set": {
        "rootObj.EvolveSalesOrderShipment_Details.EvolveSalesOrderShipment_LineDetails": "$EvolveSalesOrderShipment_LineDetails"
      }
    },
    {
      "$group": {
        "_id": "$rootObj._id",
        "rootObj": {
          "$first": "$rootObj"
        },
        "EvolveSalesOrderShipment_Details": {
          "$push": "$rootObj.EvolveSalesOrderShipment_Details"
        }
      }
    },
    {
      "$set": {
        "rootObj.EvolveSalesOrderShipment_Details": "$EvolveSalesOrderShipment_Details"
      }
    },
    {
      "$replaceRoot": {
        "newRoot": "$rootObj"
      }
    },
    {
      "$addFields": {}
    },
    {
      "$match": {
        "$and": [
          {
            "$or": [
              {
                "$expr": {
                  "$eq": [
                    "$EvolveUnit_ID",
                    {
                      "$toObjectId": "62de23659b90475655e4df50"
                    }
                  ]
                }
              }
            ]
          }
        ]
      }
    },
    {
      "$sort": {
        "_id": -1
      }
    },
    {
      "$skip": 0
    },
    {
      "$limit": 10
    }
  ])
 
 -------------------- End ---------------------------------------