Aggregation with pipeline

aggregation-with-pipeline.js

db.Vehicle.aggregate([
    {
        $match: {vin: "..."}
    },
    {
        $lookup: {
            from: 'Address',  //i want all addresses
            localField: '_vin',
            foreignField: 'vehicle.vin',
            as: 'addresses'
        }
    },
    {
        $lookup: {
            from: 'Driver',  //i wand all drivers
            localField: '_vin',
            foreignField: "vehicle.vin",
            as: "drivers"
        }
    },
    {
        $lookup: {
            from: "Upgrade",  //i only want upgrades of type "external" (the document has a field "type":"external")
            localField: "_vin",
            foreignField: "vehicle.vin",
            as: "upgrades",
            pipeline: [
                {
                    $match: {
                        type: "external"
                    }
                }
            ]
        }
    }
])