Hi, I am trying to learn to use RoR by making a simple social networking example. Given a user id, I am trying to make a query that finds all of the group that user belongs to but also rank the groups by one of the groups' parameter like group.size. Pretend group.size is a number from 1-10 and is precalculated. Can I do this is one query? Here are the relationships I set up: class User < ActiveRecord::Base has_and_belongs_to_many :groups end class Groupship < ActiveRecord::Base set_table_name "users_groups" belongs_to :recipes belongs_to :tags end class Group < ActiveRecord::Base has_and_belongs_to_many :users end Thanks!
on 2006-04-01 06:08
on 2006-04-01 11:02
This should do it. groups = user.groups.find(:all,:order => 'size') -- -- Tom M.