Forum Eloquent confused about which id column to use when using a join with eager loading

venomrush

posted 9 years ago

Eloquent

Last updated 2 years ago.

venomrush

replied 9 years ago

Solution

Got some help from someone in the laravel chatroom. The solution was the following:

$query = $this->vehicle->with('specifications')
    ->with('features')
    ->with('images')
    ->where('dealer_id', '=', $dealerId)
    ->whereHas('specification', function ($q) use ($input) 
    {
        $q->where('spec', 'Vehicle Type')
            ->where('spec_value', $input['vehicletype']);
    })
    ->paginate(10);

Last updated 9 years ago.