Getting specific column in Laravel relation returning empty array

Question

I want to get specific column from Model relation in Laravel, but the relation model returning empty array.

Eloquent Query

$medicines = Medicine::with(['weightage' => function($query) {
            $query->select('name');
        }])->get(['name', 'description']);

Medicine Modal

public function weightage()
{
    return $this->hasMany('App\MedicineWeightage', 'medicine_id');
}

shaedrich · Accepted Answer · 2021-06-30 08:19:22Z

1

You always need to also select the primary and foreign keys of the table to make the relation work:

$medicines = Medicine::with(['weightage' => function($query) {
   $query->select(['id', 'name', 'medicine_id']);
}])->get(['id', 'name', 'description']);

edited Jun 30, 2021 at 8:19

answered Jun 30, 2021 at 7:28

shaedrich

5,7633 gold badges31 silver badges47 bronze badges

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

7 Comments

Ihtisham Khan Over a year ago

still it is empty

Ihtisham Khan Over a year ago

$medicines = Medicine::with(['weightages' => function($query) { $query->select('id', 'name', 'medicine_id'); }])->select('id','name', 'description')->get(); this solved my problem

shaedrich Over a year ago

Oh, right. I forgot the id column in the parent query. Mea culpa!

Ihtisham Khan Over a year ago

Is the any way I do not send primary and foreign keys? This is API I am creating, which one is best with keys or without keys?

shaedrich Over a year ago

You can remove them from the collection via ->pluck(['name', 'description']). If you don't need them, there's no reason to expose them to the client.

|

Collectives™ on Stack Overflow

Getting specific column in Laravel relation returning empty array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related