Level 24
What database are you using?
Sep 16, 2018
4
Level 2
Why `having` only worked on fields that are `group by` on laravel eloquent?
My script laravel eloquent like this :
$query = $this->item->select('a.*','b.attribute_code')
->from('items as a')
->join('attr_maps as b','b.number','=','a.number')
->groupBy('a.number');
foreach($param as $key => $value) {
$query = $query->having($key, '=', $value);
}
$query = $query->paginate(10);
If $param is array('number'=>'1234'), it works. No error
If $param is array('description'=>'test'), there exist error : Unknown column 'description' in 'having clause'
I tried all fields in the table items. Only the number field works. Apparently because the number field is group by
How can I solve this problem?
Level 75
Here is a mysql page covering having. https://dev.mysql.com/doc/refman/8.0/en/select.html
Level 10
You can only apply HAVING to columns which appear in GROUP BY or in an aggregate function.
You should be able to use a WHERE and a HAVING clause in the same statement, try just including attributes in your params array which you are grouping by (eg. number)
Otherwise try using a WHERE clause for attributes you are not grouping by (eg. description)
Level 1
Hello @Digitalized
I have question, when I am use aggregate in eloquent relation like
$products = Product::with(['brand', 'category', 'variants'])
->filter()
->withCount([
'reviews as rating' => function ($query) {
$query->select(DB::raw('coalesce(round(avg(rating),1),0)'));
},
'reviews as review_count'
])
->withMin('variants as price', 'price')
->active()
->sort($request)
->between($request)
->min($request)
->like($request)
->simplePaginate(20)
->withQueryString()
->toArray();
and the scope like
public function scopeBetween($query, $request)
{
$between = explode(',', $request->get('between'));
return $query->when($request->has('between'), fn () => $query->havingBetween($between[0], [$between[1], $between[2]]));
}
public function scopeMin($query, $request)
{
$min = explode(',', $request->get('greater_or_equal'));
return $query->when($request->has('greater_or_equal'), fn () => $query->having($min[0], '>=', $min[1]));
}
why the error showing no price column?
Please or to participate in this conversation.