Selecting only certain columns during nested relation

Question

If I have a query: MyModal::with('relation1.relation2')->get(), how can I limit the fields selected from relation1?

MyModal::with('relation1:column1,column2')->with('relation1.relation2')->get() selects all fields on relation1.

MyModal::with('relation1:column1,column2.relation2')->get() gives an SQL error because it tries to find a column named column2.relation2.

I'm not sure what other approach there could be, so is this possible, or will fetching nested relations always fetch all fields on the first relation?

fatm · Accepted Answer · 2021-08-03 10:15:46Z

1

You should do column select after relation select: MyModal::with(['relation1.relation2', 'relation1:column1,column2'])->get()

Or you can define it in model itself

public function relation1()
{
    return $this->hasOne(Relation1::class)->select(['column1', 'column2']);
}

answered Aug 3, 2021 at 10:15

fatm

4552 silver badges11 bronze badges

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

Comments

sajjad · Accepted Answer · 2021-08-03 10:25:25Z

0

Model::query()
->with(array('relation1' => function($query) {
    $query->select('column1', 'column2');
},'relation2' => function($query) {
    $query->select('column1', 'column2');
}))
->get();

answered Aug 3, 2021 at 10:25

sajjad

586 bronze badges

Collectives™ on Stack Overflow

Selecting only certain columns during nested relation

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related