Ruby on Rails, count records of certain types

Question

I have 3 different types of records. Let say 4 records are of type A, 1 record is of type B and 10 of type C. Some users have only A and B, and others all 3 types.

First, I need to retrieve the types, and then count how many records have the type A, B or C.

Is it possible to make it in one call, so that I get a Hash from the database like following:

 A:4, B:1, C:10

ck3g · Accepted Answer · 2013-01-15 15:56:03Z

4

User.group(:type).count
=> {"A"=>4, "B"=>1, "C"=>10}

answered Jan 15, 2013 at 15:56

ck3g

5,9493 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alina Over a year ago

I mean, is it possible to do something like this: User.group(:type).count.each do |n,m| puts(n,m)?

MrYoshiji Over a year ago

@Katja Yes you can iterate like this: User.group(:type).count.each do |type, count|

Collectives™ on Stack Overflow

Ruby on Rails, count records of certain types

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related