Level 41
You might want to try this:
return Equipment::where('slug', $slug)
->with(['users.employee' => function ($query) {
$query->where('active', 1);
}])->first();
Jan 28, 2022
5
Level 5
Help with nested relationship query.
Equipment has many users. Users attach to one employee.
This query is returning 'active' for the equipment, not the employee. I need only active employees to show, but still return the equipment info if none exists.
return Equipment::where('slug', $slug)
->with(['users' => function ($query) {
$query->with(['employee' => function ($q) {
$q->where('active', 1);
}]);
}])->first();
Level 5
@kevinbui I still get the same results.
Level 104
The whereHas method will ensure you only retrieve Equiment where there are active employees
return Equipment::where('slug', $slug)
->with(['users.employee' => fn ($q) => $q->where('active', 1)])
->whereHas('users.employee', fn ($q) => $q->where('active', 1)
->first();
Level 5
@tykus I need to get the equipment info whether or not it has users attached to it.
Level 104
@ajsmith_codes In that case it is not clear what you're working with - is active on employees or on equipments
Please or to participate in this conversation.