#search ignores :order argument on associations which have an order defined

[ghost]

Consider a class Foo, with associated Bars:

@@@ ruby
class Foo < ActiveRecord::Base
has_many :bars, :order => :name
end
@@@

If you do:

@@@ ruby
Foo.bars.search(:order => "ascend_by_size").all
@@@

The results are still sorted by :name -- i.e. the "ascend_by_size" :order argument to the #search method is ignored.

The SQL query looks like:

@@@ sql
SELECT * FROM bars WHERE bars.foo_id = 1 ORDER BY bars.name;
@@@

Is this a bug?

original LH ticket

This ticket has 0 attachment(s).

[ghost]

#search ignores :order argument on associations which have an order defined

Hmm, I’m not sure, let me add a failing test and play around with it. If you want fork the project and write a quick failing test. It looks like the Searchlogic::Search#current_scope is taking priority.

by Ben Johnson

[mig]

Here is a failing spec: It's running through a defined named_scope, same issue though:

it "should overwrite ordering through a named_scope" do
  %w(bjohnson thunt).each { |username| User.create(:username => username) }
  User.class_eval {
    named_scope :by_username, :order => "username DESC"
  }
  User.by_username.ascend_by_username.should == User.all(:order => "username ASC")
end

[mig]

Hmm, looks like this is the same problem as http://github.com/binarylogic/searchlogic/issues#issue/17 which is an AR problem, not a searchlogic one