Custom hasMany relationship query with select()

Question

Each company on my app can store its own events.

A company and its events are related though the following hasMany relationship:

/**
 * The events that belong to the company.
 */
public function events()
{
    return $this->hasMany('App\Event');
}

To list a company's events, I use:

Auth::user()->company->events

Since each event stores, a lot of data that I don't need when I query the hasMany, I would like to customize the relationship to only select the id and name columns instead of the whole row.

My hasMany relationship query would be something like

DB::table('events')->where('company_id', Auth::id())->select('id', 'name')->get();

How do I take the collection returned from this result and use it as the query for my hasMany relationship, which will then correctly return a collection of event instances?

Show us your events method code from the company Model please I would suggest adding the ->select('id', 'name') part inside the relationship method. — Zakaria Acharki
– Zakaria Acharki, Commented Apr 18, 2019 at 11:43
@ZakariaAcharki I have edited my question to include the events method's code. — Dan Harrin
– Dan Harrin, Commented Apr 18, 2019 at 11:48

Community · Accepted Answer · 2021-01-12 23:21:58Z

1

Add the filter inside your events method like :

public function events()
{
    return $this->hasMany('App\Event')->select('id', 'company_id', 'name');
}

Then call it like:

Auth::user()->company->events

Important update: 'company_id' is necessary for company->events link, otherwise 'events' relationship always returns empty array

edited Jan 12, 2021 at 23:21

CommunityBot

11 silver badge

answered Apr 18, 2019 at 11:51

Zakaria Acharki

67.5k15 gold badges79 silver badges106 bronze badges

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

Comments

Haris Khan · Accepted Answer · 2019-04-18 12:23:51Z

0

How about Auth::user()->company()->with('events:id,name')->get(); https://laravel.com/docs/5.8/eloquent-relationships#eager-loading

Go to Eager Loading Specific Columns

answered Apr 18, 2019 at 12:23

Haris Khan

111 bronze badge

Collectives™ on Stack Overflow

Custom hasMany relationship query with select()

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