======================= Inventory Movement With Status, ==================== ================================================================ ~/eWms/invStatusManagement/list/ => ** db.EvolveInventory.aggregate([ { $match: { "$and": [ { "$or": [ { "EvolveInventory_QtyOnHand": { "$gt": 0 } } ] }, ] } }, { $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' } } ]) -------------------- End ---------------------------------------