How to override :order defined in a has_many

ruby-on-rails activerecord arel
Christopher picture Christopher · Nov 17, 2010 · Viewed 11k times · Source

I have

class Authors 
has_many :books, :order => 'name ASC'

I am trying to query all the books sorted by name DESC

Authors.books.order('name DESC')

but the result is

SELECT * FROM .... ORDER BY name ASC, name DESC

and the results come back with the name sorted ASC

is there a way to remove the original order in the association or override it? Or is specifying an order in a relation a bad idea?

using Rails 3.0.3

Answer

Ariejan picture Ariejan · Nov 17, 2010

Use reorder:

Authors.books.reorder('name DESC')

Related questions

How to do a LIKE query in Arel and Rails?

I want to do something like: SELECT * FROM USER WHERE NAME LIKE '%Smith%'; My attempt in Arel: # params[:query] = 'Smith' User.where("name like '%?%'", params[:query]).to_sql However, this becomes: SELECT * FROM USER WHERE NAME …

Read More
How do you scope ActiveRecord associations in Rails 3?

I have a Rails 3 project. With Rails 3 came Arel and the ability to reuse one scope to build another. I am wondering if there is a way to use scopes when defining a relationship (e.g. a "has_many"). I …

Read More
ActiveRecord Arel OR condition

How can you combine 2 different conditions using logical OR instead of AND? NOTE: 2 conditions are generated as rails scopes and can't be easily changed into something like where("x or y") directly. Simple example: admins = User.where(:kind => :admin) …

Read More