Forum Select certain columns in relation using with()

posted 9 years ago

Eloquent

Last updated 2 years ago.

replied 9 years ago

try this,

Platform::with(['rma_platform' => function($query){
    $query->select(['connectorname']);
}])->get();

Last updated 9 years ago.

replied 9 years ago

Thanks @AntiKrishnan!, but still not working. If I execute this

Platform::with('rma_platform')->get();

I get the entire relation, so the relation is OK. Any other suggestion?

replied 9 years ago

Solution

try mentioning the foreign key in the field list.

Platform::with(['rma_platform' => function($query){
    $query->select(['foreign_key','connectorname']);
}])->get();

replied 9 years ago

Like AthiKrishnan said, you need to also select the foreign keys so that Laravel can properly match the relationships.

replied 9 years ago

Thanks @AthiKrishnan, it works!!

hfuccillo hfuccillo Joined 20 Oct 2015

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community