Level 73
You can use withCount to acheive that,
Jun 23, 2021
4
Level 2
Getting an attribute to be part of a query
I would like to know if it's possible to add an attribute to be part of a query. So what I mean is that in my Product model I have an attribute function that goes like this
public function getProductInfoAttribute()
{
return sprintf("%s > %s",
'['.$this->id.'] '.$this->name, $this->categories()->count());
}
and what I would like is that when I run a query
$products = Product::where('enabled', 1)->get();
my attribute will be part of that query.
Hope that made sense
Level 55
Level 75
Don't use relationship in accessor, you get N + 1 query problem in your case.
$products = Product::withCount('categories')
->where('enabled', true)
->get()
->map(function ($product) {
$product->info = "[{$product->id}] $product->name > {$product->categories_count}";
return $product;
});
Level 122
no you cannot use an accessor in a query
Please or to participate in this conversation.