Level 70
@founderstartup Have you tried without a quote in $item->id?
e.g.
$totallistings = App\Models\Listings::whereHas('project.builder', function ($query) use ($item) {
$query->where('id', $item->id);
})->count();
1 like
Dec 17, 2021
9
Level 5
How to get correct nested eloquent query
I need to show total 'listings' in 'projects' of a 'builder'
$totallistings = App\Models\Listings::whereHas('project.builder', function ($query) {$query->where('id','$item->id');})->count();
listings is related to projects project is related to builder
Its giving nill count.
Level 102
You also need to import $item to the scope
$totallistings = App\Models\Listings::whereHas('project.builder', function ($query) use ($item) {//here
$query->where('id', $item->id);
})->count();
1 like
Level 70
Yes, that's true. @founderstartup You must use use($item).
1 like
Level 5
Thanks guys. Laracast techies are always saviours for me :)
Please or to participate in this conversation.