SUM in eloquent

SELECT
    tool_id,
    project_id,
    sum(active)
FROM activity
GROUP BY tool_id, project_id

I was able to get this far Activity::select('tool_id', 'project_id', DB::raw('SUM(active) as active')) ->groupBy(['tool_id', 'project_id']) ->get();

Is there a way to write this in eloquent without having to use DB::raw()?

gych

2 years ago

Level 29

Not as query, you can use sum() in Laravel but it will only work on collections and not queries.

The Laravel docs also make use of DB:raw to get the SUM with a query https://laravel.com/docs/11.x/queries#raw-methods

This is an example on how to use sum() on a collection https://laravel.com/docs/11.x/collections#method-sum

Snapey

2 years ago

Level 122

You can use aggregate functions in eloquent (as query builder)

https://laravel.com/docs/10.x/queries#aggregates

Please or to participate in this conversation.