Rails 3 Choose a separate order by the number of seats

Question

In one of my models, I have a country column. How can I choose the best 3 countries based on how many models this country has?

+3

Kyle decot May 05 '11 at 7:34

1 answer

tommasop · Accepted Answer · 2011-05-05T08:39:48+0000

Without additional information, you can try:

YourModel.group('country').order('count_country DESC').limit(3).count('country')

when you call the counter on field rails, it automatically adds a field to your request AS count_field_name.

The graph should be called at the end of the request because it returns an ordered hash.