Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Rails how to sum columns?

Example I have:

@test = Pakke.find([[4], [5]]) 

In my Pakke table I have a column named prismd

How do I sum the two values for the prismd columns for @test?

like image 568
Rails beginner Avatar asked Jan 15 '12 23:01

Rails beginner


1 Answers

You can summarize directly on the database by creating the respective SQL like this:

Pakke.sum(:prismd, :conditions => {:id => [4,5]}) 

On newer Rails versions (i.e. Rails >= 4.0), you can use an ActiveRecord queries more intuitively, such as:

Pakke.where(id: [4,5]).sum(:prismd) 

See ActiveRecord::Calculations for more usage examples and general documentation.

like image 94
Holger Just Avatar answered Sep 21 '22 04:09

Holger Just