================================================================
======================= Inventory List, ====================
================================================================
 ~/eSmartFactory/inventoryList/list/
 => db.EvolveInventory.aggregate([
    {
      "$sort": {
        "updatedAt": -1
      }
    },
    {
      "$match": {}
    },
    {
      "$lookup": {
        "from": "EvolveLocation",
        "let": {
          "evolveLocation_ID": "$EvolveLocation_ID"
        },
        "pipeline": [
          {
            "$match": {
              "$expr": {
                "$eq": [
                  "$_id",
                  "$$evolveLocation_ID"
                ]
              }
            }
          },
          {
            "$project": {
              "EvolveLocation_Code": 1
            }
          }
        ],
        "as": "EvolveLocation_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveLocation_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveUom",
        "let": {
          "evolveUom_ID": "$EvolveUom_ID"
        },
        "pipeline": [
          {
            "$match": {
              "$expr": {
                "$eq": [
                  "$_id",
                  "$$evolveUom_ID"
                ]
              }
            }
          },
          {
            "$project": {
              "EvolveUom_Uom": 1
            }
          }
        ],
        "as": "EvolveUom_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveUom_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$lookup": {
        "from": "EvolveItem",
        "let": {
          "evolveItem_ID": "$EvolveItem_ID"
        },
        "pipeline": [
          {
            "$match": {
              "$expr": {
                "$eq": [
                  "$_id",
                  "$$evolveItem_ID"
                ]
              }
            }
          },
          {
            "$project": {
              "EvolveItem_Code": 1,
              "EvolveItem_Desc1": 1,
              "EvolveItem_Desc2": 1
            }
          }
        ],
        "as": "EvolveItem_ID"
      }
    },
    {
      "$unwind": {
        "path": "$EvolveItem_ID",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$match": {
        "$and": [
          {
            "$or": [
              {
                "$expr": {
                  "$eq": [
                    "$EvolveUnit_ID",
                    {
                      "$toObjectId": "62de23659b90475655e4df50"
                    }
                  ]
                }
              }
            ]
          }
        ]
      }
    },
    {
      "$addFields": {
        "EvolveItem_Code": "$EvolveItem_ID.EvolveItem_Code",
        "EvolveItem_Desc": {
          "$concat": [
            "$EvolveItem_ID.EvolveItem_Desc1",
            " ",
            "$EvolveItem_ID.EvolveItem_Desc2"
          ]
        },
        "EvolveLocation_Code": "$EvolveLocation_ID.EvolveLocation_Code",
        "EvolveUnit_Code": "CFD01",
        "EvolveUom_Uom": "$EvolveUom_ID.EvolveUom_Uom",
        "EvolveInventory_Qty": {
          "$round": [
            "$EvolveInventory_Qty",
            3
          ]
        },
        "EvolveInventory_QtyOnHand": {
          "$round": [
            "$EvolveInventory_QtyOnHand",
            3
          ]
        },
        "EvolveInventory_QtyAllocated": {
          "$round": [
            "$EvolveInventory_QtyAllocated",
            3
          ]
        },
        "EvolveInventory_QtyPicked": {
          "$round": [
            "$EvolveInventory_QtyPicked",
            3
          ]
        }
      }
    },
    {
      "$skip": 0
    },
    {
      "$limit": 10
    }
  ])
 -------------------- End ---------------------------------------