tags:

views:

31

answers:

1
Q: 

ActiveRecord query help .count

I have a DB table users that has the following columns: id, clan_id, experience

I want to run a query using rails that returns the top 50 clans based on experience. How would you do this query in rails?

Clan Table to User Table is a one to many relationship. Thus a clan is composed of multiple users that have the same id.

+2  A:  
Clan.find(:all, :order => "experience DESC", :limit => 50)
Toby Hede  2010-02-15 08:24:19
clan table to user table is a one to many relationship. It is possible for a clan to have more than one user. I've updated the question to reflect this
Splashlin  2010-02-15 08:29:22
This answer does exactly what you're looking for. You want 50 Clans sorted by `experience`. You should run the above query on the `Clan` model. The users table has nothing to do with your question whatsoever.
Ben  2010-02-15 16:57:40
edited to explicitly use "clan" model
Toby Hede  2010-02-16 00:00:37
Can you post the code that returns that error? Where is the path_revenue value coming from?
Toby Hede  2010-02-16 06:10:57

related questions

Is there a rake task for backing up the data in your database?
How to represent cross-model information in MVC?
WYSIWYG editor gem for Rails?
Best Solution For Authentication in Ruby on Rails
Acts-as-readable Rails plugin Issue
Associating source and search keywords with account creation
Any tips on getting Rails to run with an Access back-end?
Being as DRY as possible in a Ruby on Rails App
How Do You Secure database.yml?
What IDE to use for developing in Ruby on Rails on windows?
Is Ruby On Rails ready for the Enterprise?
OpenID authentication in Ruby on Rails
Why Doesn't My Cron Job Work Properly?
Why does sqlite3-ruby-1.2.2 not work on OS X?
Ruby mixins and calling super methods
Why all the Active Record hate?
Haml: how do I set a dymanic class value?
Learning Ruby on Rails any good for Grails?
How to sell Python to a client/boss/person with lots of cash
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Ruby On Rails with Windows Vista - Best Setup?
What is good forum software to add to an existing Rails application?
How do I fix 'Unprocessed view path found' error with ExceptionNotifier plugin in rails 2.1?
Frequent SystemExit in Ruby when making HTTP calls
Implementation of "Remember me" in a Rails application.