Selecting specific columns using laravel eager loading doesn't work

Question

I am really not getting why this eager loading is not working when I try to return specific columns. This code works perfectly

$user=User::where('userName', $userName)
        ->with('points')
        ->with('examstaken')
        ->with('question')
        /*->with(array('points'=>function($query){
                $query->select('id','points');
         }))*/
         ->get();

This code doesn't wort

$user=User::where('userName', $userName)
        /*->with('points')*/
        ->with('examstaken')
        ->with('question')
        ->with(array('points'=>function($query){
                $query->select('id','points');
         }))
         ->get();

Doesn't work mean, 'points' doesn't return any value while the first one return the values correctly..

Any idea what's wrong with it?

Here is the relation in my user model

  public function points()
{
    return $this->hasMany('App\Points','user_id');
}

Thanks..

Hkm Sadek · Accepted Answer · 2017-12-10 06:49:35Z

5

Ok solved it. It seems I have to pass the user_id, the foreign key and then they it will work. Posting it as answer as someone else may get help :)

$user=User::where('userName', $userName)
        /*->with('points')*/
        ->with('examstaken')
        ->with('question')
        ->with(array('points'=>function($query){
                $query->select('user_id','points');
         }))
         ->get();

answered Dec 10, 2017 at 6:49

Hkm Sadek

3,22913 gold badges52 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lagbox Over a year ago

if you don't select the keys needed for the relationship, Eloquent wont be able to match up the children to their parents by key

Collectives™ on Stack Overflow

Selecting specific columns using laravel eager loading doesn't work

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related