Level 50
You can use whereHas for this:
$category->whereHas('events', function($query) {
$query->where('approved', Null);
})->get();
Docs: https://laravel.com/docs/5.8/eloquent-relationships#querying-relationship-existence
Mar 27, 2019
8
Level 10
How do I filter the eager loading results?
Hi All,
I am trying to understand how to filter my eager loaded results. In my show method on my category controller I have
public function show(Category $category)
{
$category->load('events');
return view('category.show', compact('category'));
}
This returns my current category with the eager loaded events so my relationships are working. My question is how do I filter those returned events. I guess I should use a where() method but when I use
$category->load('events')->where('approved', Null)->get();
It is searching my categories class for the approved column, not my events class. Is there a way to tell Laravel to search the eager loaded class?
Thanks!
Level 10
When I use
public function show(Category $category)
{
$category->load('events')->whereHas('events', function($query) {
$query->where('approved', !Null);
})->get();
return view('category.show', compact('category'));
}
It is still returning all the events, even the ones with Null. I have also been looking into adding a method on my category.php file like
function eventFiltered()
{
return $this->
hasMany(Event::class)
->wherePivot('approved', !null );
}
Would this also be another solution?
Level 50
@CHRISGRIM - You can pass a closure to the loaded class, and maybe this will work for you:
$category = $category->load(['events' => function ($query) {
$query->whereNotNull('approved');
}])->get();
Does it work?
Level 10
I tried using
public function show(Category $category)
{
$category = $category->load(['events' => function ($query) {
$query->whereNotNull('approved');
}])->get();
return view('category.show', compact('category'));
}
and got the issue
"Property [categoryName] does not exist on this collection instance.
Level 122
$category->load(['events' => function ($query) {
$query->whereNotNull('approved');
}])->get();
remove $category=
1 like
Level 10
That did it! Just to understand, why did removing the $category = fix it?
Thanks Chris
Level 122
you are assigning the resukt of get() to $category. Im not sure what it returns but it could be just a boolean, or a record count
dd() it and see !
what you want to do is work with the object you already have.
and the load using a function comes under the heading of constraining eager loads
https://laravel.com/docs/5.7/eloquent-relationships#constraining-eager-loads
Level 10
Gotcha! Thank you so much for taking the time to explain. :)
Please or to participate in this conversation.