How to select specific column from model while using eager loading : laravel

Question

I have successfully retrieved data using eager loading as following:

$var = Question::with(['asker'=>function($query){
        $query->select('id','username');
    }])->get();

The problem is that I am unable to choose specific columns from the model Question. I have tried the following:

$var = Question::select('q_id','title')->with(['asker'=>function($query){
        $query->select('id','username');
    }])->get();

$var = Question::with(['asker'=>function($query){
        $query->select('id','username');
    }])->get(['q_id','title']);

In both cases, it returned null value for asker while choosing q_id and title.

What does your Question model look like? It might be helpful to see the relationship between the question and the asker. — Carter Fort
– Carter Fort, Commented Dec 21, 2016 at 17:36

Alexey Mezenin · Accepted Answer · 2016-12-21 17:31:25Z

4

You also need to select foreign key, so Eloquent could find relation:

$var = Question::with(['asker' => function($query){
    $query->select('id', 'username', 'question_id');
}])->get();

answered Dec 21, 2016 at 17:31

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Alexey Mezenin Over a year ago

Do you get null for relation? Does it work if you remove the closure? Is question_id correct name of foreign key?

uttejh Over a year ago

yeah null for ralation and it works and askedby is the foreign key. Thanks for the effort.

uttejh · Accepted Answer · 2016-12-21 17:49:03Z

1

I had to include the foreign key while selecting data from the model.

$var = Question::select('q_id','title','askedby')->with(['asker'=>function($query){
    $query->select('id','username');
}])->get();

The extra field 'askedby' had to be included. Thanks for the clue.

answered Dec 21, 2016 at 17:49

uttejh

1841 silver badge15 bronze badges

2 Comments

Alexey Mezenin Over a year ago

So, you didn't actually try my code, but said it didn't work. select for Question model was removed so my code should work.

uttejh Over a year ago

not really. I tried then the error stated as askedby is not found in the TABLE(i also tried the other key) and then thought including it in the select statement.

Collectives™ on Stack Overflow

How to select specific column from model while using eager loading : laravel

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related