======================= Work Order Report, ====================
================================================================
 ~/eSmartFactory/workOrderReport/list/
 => db.EvolveWorkOrder.aggregate([
    {
      "$lookup": {
        "from": "EvolveItem",
        "localField": "EvolveItem_ID",
        "foreignField": "_id",
        "as": "EvolveItem_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveItem_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$unwind": "$EvolveWorkOrderBomDetails"
    },
    {
      "$lookup": {
        "from": "EvolveItem",
        "localField": "EvolveWorkOrderBomDetails.EvolveItem_ID",
        "foreignField": "_id",
        "as": "EvolveWorkOrderBomDetails.EvolveItem_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveWorkOrderBomDetails.EvolveItem_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$group": {
        "_id": "$_id",
        "EvolveWorkOrder_OrderNo": {
          "$first": "$EvolveWorkOrder_OrderNo"
        },
        "EvolveWorkOrder_OrderID": {
          "$first": "$EvolveWorkOrder_OrderID"
        },
        "EvolveItem_ID": {
          "$first": "$EvolveItem_ID"
        },
        "EvolveWorkOrder_Qty": {
          "$first": "$EvolveWorkOrder_Qty"
        },
        "EvolveWorkOrder_QtyCompleted": {
          "$first": "$EvolveWorkOrder_QtyCompleted"
        },
        "EvolveWorkOrderBomDetails": {
          "$push": "$EvolveWorkOrderBomDetails"
        }
      }
    }
  ])
 
 -------------------- End ---------------------------------------