======================= WorkOrder Picklist, ====================
================================================================
 /eSmartFactory/workOrderPickList/list/
 => 
 db.EvolvePickList.aggregate([
    {
        $match: {
            $and: [
                { 
                    EvolvePickList_Type : "WO"
                }
            ]
        }
    },
    { $unwind: '$EvolvePickListDetails' },
    {
        "$lookup": {
            "from": "EvolveItem",
            "localField": "EvolvePickListDetails.EvolveItem_ID",
            "foreignField": "_id",
            "as": "EvolvePickListDetails.EvolveItem_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolvePickListDetails.EvolveItem_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveUom",
            "localField": "EvolvePickListDetails.EvolveUom_ID",
            "foreignField": "_id",
            "as": "EvolvePickListDetails.EvolveUom_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolvePickListDetails.EvolveUom_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveSalesOrder",
            "localField": "EvolvePickListDetails.EvolveSalesOrder_ID",
            "foreignField": "_id",
            "as": "EvolvePickListDetails.EvolveSalesOrder_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolvePickListDetails.EvolveSalesOrder_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        $unwind: {
            path: "$EvolvePickListDetails.EvolveAllocatedInvDetails",
            preserveNullAndEmptyArrays: true
        }
    },

    {
        "$lookup": {
            "from": "EvolveLocation",
            "localField": "EvolvePickListDetails.EvolveAllocatedInvDetails.EvolveLocation_ID",
            "foreignField": "_id",
            "as": "EvolvePickListDetails.EvolveAllocatedInvDetails.EvolveLocation_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolvePickListDetails.EvolveAllocatedInvDetails.EvolveLocation_ID",
            preserveNullAndEmptyArrays: true
        }
    },

    {
        $group: {
            "_id": "$EvolvePickListDetails._id",
            "rootObj": {
                "$first": "$$ROOT"
            },
            "EvolveAllocatedInvDetails": {
                $push: "$EvolvePickListDetails.EvolveAllocatedInvDetails"
            },

        }
    },
    {
        $set: {
            "rootObj.EvolvePickListDetails.EvolveAllocatedInvDetails": "$EvolveAllocatedInvDetails"
        }
    },
    {
        $group: {
            "_id": "$rootObj._id",
            "rootObj": {
                "$first": "$rootObj"
            },
            "EvolvePickListDetails": {
                $push: "$rootObj.EvolvePickListDetails"
            },

        }
    },
    {
        $set: {
            "rootObj.EvolvePickListDetails": "$EvolvePickListDetails"
        }
    },
    {
        $replaceRoot: {
            newRoot: "$rootObj"
        }
    },
    {
        $match: {}
    },

    {
        $sort: {
            _id:
                -1
        }
    },
    { $skip: 0 }, { $limit: 1 },
    {
        $facet: {
            result: [],
        }
    },

])
 -------------------- End ---------------------------------------