Group and count in Rails

user_222347 0
Viewed 77106

I know I've seen this before but I can't find anything now. I want to group a query by a certain column and be able to display how many are in each group. I got the first part down: 

@line_items = @project.line_items.all(:group => "device_id")

This is for my line item index view, which is just a table displaying the line items. How do I make a column in that table for "count" now that the line items are grouped by device?

count ruby-on-rails
7 Answers

You can do count on line_items which will return you an ordered hash of device_id and count.

@project.line_items.group(:device_id).count
user_2231960

Just add a :select option:

@line_items = @project.line_items.all(
  :group  => "device_id",
  :select => "device_id, COUNT(*) as count"
)

Then each @line_item will have a count attribute.

user_2297610
Related