My app contains categories, service and discounts.
A category has_many :services
A service belongs_to :category and has_one discount
A discount belongs_to :service
On each category show page I list all of the associated services, but
would like to order them by some of the entries in the discount
i.e. in my categories controller
@category = Category.find(params[:id]) @services=Service.find(:all, :order => "XXXXXXX", :conditions =>
[‘category_id = ?’, @category.id])
where XXXX relates to one of the columns in the discount table. The
column gives the % discount available stored as an integer field.
Any ideas on best practice here,
I thought I could write a method into the Service.rb model file but
although I can call the value easily I can’t order by the entry.
All help appreciated.