Laravel eager loading specific columns error

Question

I have custom code where I must get specific columns from relation data:

$jobs = Job::with('user:id, name')
           ->where('type', 0)
           ->where('status', 1)
           ->orderBy('updated_at', 'DESC')
           ->get();

When I run this code Laravel return me error message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ' name' in 'field list'

How can I solve this error?

Here is my `$fillable` variable values: `protected $fillable = ['name', 'email', 'password', 'phone', 'status'];` — Andreas Hunter, Sep 12 '19 at 05:56
@AndreasHunter Space is a Problem here so remove space only. — Jignesh Joisar, Sep 12 '19 at 06:00
Does this answer your question? [Get Specific Columns Using “With()” Function in Laravel Eloquent](https://stackoverflow.com/questions/19852927/get-specific-columns-using-with-function-in-laravel-eloquent) — miken32, Apr 05 '23 at 16:20

score 4 · Accepted Answer · answered Sep 12 '19 at 05:57

4

In this code has space with('user:id, name'). Problem is space.
Try this one

$jobs = Job::with('user:id,name')
    ->where('type', 0)
    ->where('status', 1)
    ->orderBy('updated_at', 'DESC')
    ->get();

answered Sep 12 '19 at 05:57

Davit Zeynalyan

8,418
5
30
55

score 4 · Answer 2 · answered Sep 12 '19 at 06:04

It can be done one by passing a closure function in with() as second index of array like

$jobs = Job::with(['user' =>  function($q){
                $q->select('id','name');
            }])->where('type', 0)
               ->where('status', 1)
               ->orderBy('updated_at', 'DESC')
               ->get();

Laravel eager loading specific columns error

2 Answers2