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

========   Inventory ListBy Filter   ===============

========   ~/eWms/inventoryListByFilter/list/    ===============

db.EvolveInventory.aggregate([
    {
      "$sort": {
        "updatedAt": -1
      }
    },
    
    {
      "$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
      }
    },
  

    {
      "$count": "c"
    },
  ])

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