Laravel Eager Loading - Load only specific columns

Question

I am trying to eager load a model in laravel but only return certain columns. I do not want the whole eager loaded table being presented.

public function car() {     return $this->hasOne('Car', 'id')->get(['emailid','name']); } 

I am getting the following error:

log.ERROR: exception 'Symfony\Component\Debug\Exception\FatalErrorException' with message 'Call to undefined method Illuminate\Database\Eloquent\Collection::getAndResetWheres()'

Answer 1

Make use of the select() method:

public function car() {     return $this->hasOne('Car', 'id')->select(['owner_id', 'emailid', 'name']); } 

Note: Remember to add the columns assigned to the foreign key matching both tables. For instance, in my example, I assumed a Owner has a Car, meaning that the columns assigned to the foreign key would be something like owners.id = cars.owner_id, so I had to add owner_id to the list of selected columns;

Answer 2

Also you don't need to specify getting specific columns in the model and the relationship method itself... You can do that whenever you need it... Like this:

$owners = Owner::           with([               'car' => function($q)                {                     $q->select('id', 'owner_id', 'emailid', 'name');                },                'bike' => function($q)                {                     $q->select('id', 'owner_id', 'emailid', 'name');                }           ])->           get(); 

In this way you can also get all of the columns of the related model if you have ever needed to.