CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3activerecord
Mohit Jain
Mohit Jain

Reputation: 43959

How to write a query for grouping records in Ruby on Rails?

I want to get all the users count based upon the created at

   User.group("Date(created_at)").count

It will give me a output like

 {Wed, 03 Aug 2011=>25, Thu, 04 Aug 2011=>22, 06 Aug 2011=>4, Sun, 07 Aug 2011=>6, Mon, 08 Aug 2011=>5}

I want to have an array something like:-

 [25,22,0,4,5]  // zero is for the dates when no record is there for that date.

Upvotes: 0

Views: 87

Answers (1)

Kristian PD
Kristian PD

Reputation: 2695

@foo = User.group(:created_at).count will give you your users grouped by their created_at date.

As you mentioned you'll get a hash of {:date => count}'s

You could then look at @foo.values (to get your count array) [25,22,0,4,5], or iterate over it like

@foos.each_pair do |date, count|
  puts "#{date}: #{count}"
end

EDIT I now understand what you were trying to ask.

You could do something like this

start_date = Date.today - 7.days
end_date = Date.today
@foo = User.group("DATE(created_at)").where(:created_at => start_date..end_date).count
counts = (start_date..end_date).map{ |d| @foo[d] || 0 }

Upvotes: 2

Related Questions