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 -- Posted via http://www.ruby-forum.com/. -- 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.
