"you're probably going to want to display at least some of the fields from Contact"
exactly... I show the thing I'm sorting on (last_name) along with a number of other attr's On Nov 18, 9:32 am, Matt Jones <[email protected]> wrote: > :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=.
