Sumeet Panchal wrote:
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'
CustomerAddress(fields city, customer_id, state)
so basically I have many addresses for a customer, and one of which is
primary address. so I have this relations ship
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.
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.