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=en
-~----------~----~----~----~------~----~------~--~---