Can someone help me with this query ?
Here is the query used in rails 2. The idea here is to obtain the top
Widget.find(:all, :select => ‘widget_type_id, COUNT(widget_type_id) AS
widgettypeid’, :group => ‘widget_type_id’, :order => ‘widgettypeid
DESC’, :limit => 10)
This is deprecated and i want to port it to rails 3.
Thanks for your help.
I’m not sure how to do the “COUNT(widget_type_id) AS widgettypeid” as
this doesn’t seem to work below but it is close. hoping someone will
chime in. I’m sure I’m missing something simple.
count(widget_type_id) AS widgettypeid’).order(:widgettypeid).limit(10)
No docs on this at
but guide has some examples.
This seems to work perfectly for me. Thanks for your help. I will take
a big look at this to understand how it is working.