Forum eloquent query multiple relations deep

kryptonit3

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

lagbox

replied 10 years ago

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

kryptonit3

replied 10 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 10 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 10 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 10 years ago.