With ActiveRecord, how do I sort results using associations?
For example, I have
class Roster < ActiveRecord
# name => text
has_many :members
end
class Member < ActiveRecord
# zip_code => integer
belongs_to :roster
end
I would like to generate a list of members, grouped by roster name,
sub-sorted by zip code.
Something like this: Member.order("roster.name, zip_code").all
But I can't get the syntax quite right - I've played around with join
and include - can anyone tell me the right syntax to use??
thanks, Andy
--
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-t...@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.
