======================= Invoice History, ==================== ================================================================ ~/Compliance/Invoice/history/ => db.EvolveInvoice.aggregate([ { $match: { $and: [ { $or: [ { EvolveInvoice_Status: { $regex: '^COMPLETED$', $options: 'i' } } ] } ] } }, { $lookup: { from: 'EvolveUnit', localField: 'EvolveUnit_ID', foreignField: '_id', as: 'populatedEvolveUnit' } }, { $lookup: { from: 'EvolveEINVDoc', localField: 'EvolveEINVDoc_ID', foreignField: '_id', as: 'populatedEvolveEINVDoc' } } ])