OrderBy Sum in Laravel

Question

How would I go about ordering a sum in Laravel

Currently, using

Auth::user()->activities()->groupBy('attempts_id')->sum('points');

Will only give me the first row. I need to order by that sum in descending order and grab the first item.

Using ->get() at the end results in an error: Call to a member function get() on a non-object

score 6 · Accepted Answer · answered Jan 12 '15 at 22:48

6

Try this:

Auth::user()
    ->activities()
    ->groupBy('attempts_id')
    ->orderByRaw('SUM(points) DESC')
    ->first();

answered Jan 12 '15 at 22:48

lukasgeiter

Thanks so much. That combined with a raw select did the trick. – gin93r Jan 12 '15 at 22:53
You're welcome. Yes if you need the actual value in the result you have to use a raw select :) – lukasgeiter Jan 12 '15 at 22:54

1 Answers1