Forum ORM where clause on related table with pluck

webcoweb

posted 5 years ago

Eloquent Laravel Database

Last updated 1 year ago.

thyrosis

replied 5 years ago

Hi Nima,

Get the results first and then pluck the field from the collection. So like this:

$Result = TableA::with('tableB')
    ->where('fieldA', $valueA)->whereHas('tableB', function($query){
    // Now querying on tableB
    $query->where('fieldB', $valueB);
})->get()->pluck('fieldB')->toArray();

This will use the collection's pluck method, not the query builder's. I don't know if that's what you're looking for, but I assume it'll work just as well.