:joins will work as well - but with the additional gotcha that it (by default) does an inner join, so UpdateRequests without an associated contact won't get loaded if you use the :joins => :contact syntax. Been bitten by this at least once myself...
Also, :include could be useful here anyway, as you're probably going to want to display at least some of the fields from Contact with the requests (else the sort will look really weird). --Matt Jones On Nov 17, 3:49 pm, Frederick Cheung <[email protected]> wrote: > On Nov 17, 6:03 pm, lunaclaire <[email protected]> wrote: > > > That did work, Matt. Thx! > > > This finally pushes me to learn more about :include, something I > > havent looked at much in a couple years of Rails work <sheepish grin> > > I'd use :joins instead of include here - you'll actually be loading > all those contact objects whenever you load that association, which > probably isn't what you want. > > Fred > > > > > Thx again to all > > > On Nov 17, 7:27 am, Matt Jones <[email protected]> wrote: > > > > 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=.
