Group and count in Rails

Ruby on-RailsCount

Ruby on-Rails Problem Overview


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?

Ruby on-Rails Solutions


Solution 1 - Ruby on-Rails

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

Solution 2 - Ruby on-Rails

hash of devise_id as key and associated records count

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

Solution 3 - Ruby on-Rails

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.

Solution 4 - Ruby on-Rails

I think you can try this as well.

@project.line_items.group(:device_id).pluck("device_id, count(device_id)")

^^ This gives array of arrays with elements 'device_id and count'

Solution 5 - Ruby on-Rails

something like

 User.all(:joins => :comments, :select => "users.*, count(comments.id) as comments_count", :group => "users.id")

might also work...

Solution 6 - Ruby on-Rails

After this commit:

https://github.com/rails/rails/commit/a1c05dd8b9bd3623289d3aa73dda2943d620cc34

there's a new way to do the same thing:

@project.line_items.count(:group => LineItem.arel_table[:device_id])

Solution 7 - Ruby on-Rails

For only count pluck would be faster here rather than group

@project.line_items.pluck(:device_id).count


@project.line_items.pluck(:device_id).uniq.count

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestiontladukeView Question on Stackoverflow
Solution 1 - Ruby on-RailsChandra PatniView Answer on Stackoverflow
Solution 2 - Ruby on-RailsSandip RansingView Answer on Stackoverflow
Solution 3 - Ruby on-RailsAlex ReisnerView Answer on Stackoverflow
Solution 4 - Ruby on-RailsbluefoggyView Answer on Stackoverflow
Solution 5 - Ruby on-RailsrogerdpackView Answer on Stackoverflow
Solution 6 - Ruby on-RailsPsyloneView Answer on Stackoverflow
Solution 7 - Ruby on-RailsJohn SmithView Answer on Stackoverflow