Solution
Ok guys, i just found out what was missing, a subquery in the county whereHas, pretty noobie error that i found in the queryLog. This may serve for someone in the future.
Paginator::setPageName('page_pools'); $pools = Team::where('team_type','=','pool') ->whereHas('users',function ($q) { $q->whereHas('roles', function ($q){ $q->where('name','NOT LIKE', '%Admin%'); }); }) ->whereHas('county', function($q) use ($filter){ ( $q->where(function($q2) use ($filter) { $q2->where('name','LIKE','%'.$filter.'%')->where('abrev','LIKE','%'.$filter.'%','OR'); }));}) ->paginate(9);
Last updated
1 year ago.
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast