================================================================ ======================= Inventory Movement, ==================== ================================================================ /eSmartFactory/InventoryMovement/list/ => *ppopulate* db.EvolveInventory.aggregate([ { $match: { "$and": [ { "$or": [ { "EvolveInventory_QtyOnHand": { "$gt": 0 } } ] }, { "$or": [ { "EvolveInventory_Status": { "$regex": "^AVAILABLE$", "$options": "i" } } ] }, ] } }, { $lookup: { from: "EvolveUnit", localField: "EvolveUnit_ID", foreignField: "_id", as: "EvolveUnit_ID" } }, { $lookup: { from: "EvolveItem", localField: "EvolveItem_ID", foreignField: "_id", as: "EvolveItem_ID" } }, { $lookup: { from: "EvolveUom", localField: "EvolveUom_ID", foreignField: "_id", as: "EvolveUom_ID" } }, { $lookup: { from: "EvolveLocation", localField: "EvolveLocation_ID", foreignField: "_id", as: "EvolveLocation_ID" } }, { $match: { "$and": [ { "$or": [ { "EvolveLocation_IsVendor": { "$ne": true } } ] } ] } } ]) -------------------- End ---------------------------------------