Forum ORM query - where clause on related table

meowts

posted 9 years ago

Eloquent

Last updated 1 year ago.

meowts

replied 9 years ago

The solution I came up with is this:

$tableA = TableA::with('tableB')
        ->join('tableB', 'tableB.id', '=', 'tableA.tableB_id')
        ->where('tableA.fieldA', '=', valueA)
        ->where('tableB.fieldB', '=', valueB)
        ->orderBy('created_at', 'DESC')->paginate(10);

That join of course does affect query performance though.

Last updated 1 year ago.

iwader

replied 9 years ago

Solution

Assuming you've setup one of the Eloquent relations you can use the following. http://laravel.com/docs/eloquent#querying-relations

TableA::with('tableB')
    ->where('fieldA', $valueA)
    ->whereHas('tableB', function($query)
{
    // Now querying on tableB
    $query->where('fieldB', $valueB);
})->orderBy('created_at', 'DESC')
    ->paginate(10);

Last updated 1 year ago.