Solution
Columns should be in an array or as individual parameters. Try:
public function scopeGroupByMonth($query)
{
return $query->select(array('*', DB::raw('MONTH(display_date) as `month`'), DB::raw('YEAR(display_date) as `year`'), DB::raw('sum(value) as `sum`')))
->groupBy('user_id', 'month', 'year');
}
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast