Laravel relation based on column from main table

Question

So this is the query I have constructed so far

$data['requested_units'] = RequestedUnit::with([
    'user',
    'agent_warrants' => function ($q) {
        $q->where('type', RequestedUnit::AgentSecurityWarrant);
    }
])
->where('status', RequestedGrant::REQUESTED)
->get();

the problem is that it assumes the 'type' column is in the table 'agent_warrants' but actually it is in the parent table i-e RequestedUnit , how to specify this?

->with([ 'agent_warrants' => function($query) { $query->where('type',RequestedUnit::AgentSecurityWarrant) }]) — francisco
– francisco, Commented May 27, 2024 at 11:38
this assumes that type column is in agent_warrants , i want to specify that type columns is in the parent table requested_unit — Arsalan Khan
– Arsalan Khan, Commented May 27, 2024 at 11:40
You want to load agent_warrants when the type of RequestedUnit is RequestedUnit::AgentSecurityWarrant ? — Maraboc
– Maraboc, Commented May 27, 2024 at 12:01
@Arsalan Khan can't you do just RequestedUnit::where('type',RequestedUnit::AgentSecurityWarrant) }]) and then ->with(['agent_warrants']) — francisco
– francisco, Commented May 27, 2024 at 12:47

IGP · Accepted Answer · 2024-05-27 17:10:22Z

0

You can't specify that in the query. with will load the relationships for every result.

However, you can use load after getting the results on a subset you obtain with a filtering method such a where, filter or reject

$data['requested_units'] = RequestedUnit::with([
    'user',
])
->where('status', RequestedGrant::REQUESTED)
->get();

$data['requested_units']
    ->where('type', RequestedUnit::AgentSecurityWarrant) // collection method
    ->load('agent_warrants');

answered May 27, 2024 at 17:10

IGP

16.4k5 gold badges34 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Laravel relation based on column from main table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related