Forum eloquent query multiple relations deep

kryptonit3

posted 9 years ago

Database Eloquent

Last updated 2 years ago.

lagbox

replied 9 years ago

Look into whereHas for filtering the result based upon existence of relationship.

kryptonit3

replied 9 years ago

not sure where to start on that. read somewhere that whereHas doesn't play nice with nested relations (user.group).

would you have an example that would pertain to my data structure?

kryptonit3

replied 9 years ago

$c = Company::whereHas('user', function($q)
{
	$q->whereHas('group', function($q)
	{
		$q->where('name_short', '=', 'user');
	});
});

#print_r($c->toJSON());
print_r($c);

Just tried that and my browser crashed, assuming that is not the solution. I feel I am close though.

kryptonit3

replied 9 years ago

Solution

Figured it out :)

$c = Company::where('active','=',1)->whereHas('user', function($q)
{
	$q->whereHas('group', function($q)
	{
		$q->whereIn('group.name_short', array('admin','user'));
	});
})->get();

Last updated 9 years ago.