Ordering by associated columns (pleeease help)

Sumeet Panchal wrote:

Hi,

I am stuck pretty bad please help. any comment is helpful.
I have say three models
Customer(fields are id, name, cell_phone, primary_address_id)
   belongs_to :primary_address, :class_name =>
'CustomerAddress', :foreign_key => 'primary_address_id'
   has_many :customer_addresses
end

CustomerAddress(fields city, customer_id, state)
   belongs_to :customer
end

so basically I have many addresses for a customer, and one of which is
primary address. so I have this relations ship
customer.primary_address.

Now I want to write a query by using find or paginate. like:
Customer.find [arra of id], :order => "primary_address.city ASC"
The problem is that it is not ordering by associated columns. It says
no column primary_address.city found.
I am trying to use include but it do not works, :join how can I use
it. Please help is there any way to order by associated columns.

Thanks
Sumeet Panchal

You can use join as Customer.find(:all, :joins => "customers inner join
customer_address as b on customers.primary_address_id=b.id") and in this
you can use ordering.

Anubhaw

join will work, even :include will work.
but this reduce performance for query.