The easiest way to get the contacts table into the mix is to
use :include on the has_many:

has_many :update_requests, :dependent => :destroy, :include
=> :contact, :order => 'contacts.last_name asc'

I'm not 100% sure that this will actually sort the records the way you
want, however. If it doesn't work, you'll probably need to build a
named scope on UpdateRequest that sorts by contact last_name.

--Matt Jones


On Nov 16, 10:02 pm, lunaclaire <[email protected]> wrote:
> here are my models (only showing the associations that relate to this
> post):
>
> class UpdateRequest < ActiveRecord::Base
>         belongs_to      :user
>         belongs_to      :contact
> end
>
> class User < ActiveRecord::Base
>         has_many        :update_requests, :dependent => :destroy
> end
>
> so I want to be able to list UpdateRequests and sort them based on
> attributes of the referenced Contact in each
>
> I cant, for instance, do the following for the User
>
>        has_many :update_requests, :dependent => :destroy, :order =>
> 'contacts.last_name asc'
>
> It doesnt know about the 'contacts' table's columns
>
> I can do this, right? How?
>
> Thx
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to