I'm trying to gather and display some simple statistical data. I want to display the number of Products created over the last month, grouped by the day they were created. Am I on the right track as far as the ActiveRecord finder and also how would I iterate over the results in the view to spit out the date and the count of products for that day? Thanks for any help.
# example sql that returns count and date, grouped by the date SELECT count(*) as total, created_at as date FROM products GROUP BY date(created_at) HAVING created_at >= '2009-07-31' and created_at <= '2009-08-31'; # AR finder? @created_products = Product.find(:all, :group => "date (created_at)", :having => ["created_at >= ?", 1.month.ago]) # view code? <ul> <li>Date : Total</li> </ul> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---