Remove order from ActiveRecord scope

Question

I'm using rails ransack ( https://github.com/ernie/ransack ) to allow the users to filter and sort some records. I get the filtered and sorted records using traditional methods.

 @invoices = Invoice.search(params[:q]).result

Now I would like to get some summary information so I have

 @invoices = Invoice.search(params[:q]).result
 @summary = @invoices.select("sum(balance) as balance_total").first

Except when the user specifies a field to sort. I get the SQL error:

 Column "project_name" is invalid in the ORDER BY clause because 
 it is not contained in either an aggregate function or the GROUP BY clause

Can I remove the sort from the scope? How?

Thanks

hmmm now ransack isn't liking the select on the result set, not sure it worked without the sort issue anymore. — jrhicks, Feb 28 '12 at 23:57

Mori · Accepted Answer · 2012-02-28 23:34:15Z

up vote 103 down vote accepted

You can call the reorder method with an empty string. E.g.:

[1] pry(main)> Article.order('headline asc').to_sql
=> "SELECT `articles`.* FROM `articles`  ORDER BY headline asc"
[2] pry(main)> Article.order('headline asc').reorder('').to_sql
=> "SELECT `articles`.* FROM `articles` "

answered Feb 28 '12 at 23:34

Mori

19.3k45061

6

Note: If it feels better to you, can also call .reorder(nil). – pdobb Nov 13 '16 at 18:22

1

Another option is to use unscope(:order) – Rene Jun 13 at 16:48

add a comment |

Chris Bloom · Answer 2 · 2012-03-25 19:01:07Z

up vote -2 down vote

You can also use the unscoped class method in Rails 3:

class Post < ActiveRecord::Base
  default_scope :published => true
end

posts = Post.all #=> SELECT * FROM posts WHERE published = true

posts = Post.unscoped do
  Post.all #=> SELECT * FROM posts
end

In Rails 2 it was called with_exclusive_scope.

See https://github.com/rails/rails/commit/bd1666ad1de88598ed6f04ceffb8488a77be4385

answered Mar 25 '12 at 19:01

Chris Bloom

2,13612339

22

A word of warning to people using unscoped: It does more than just reset the order! If you are using it in a chained ActiveRecord query, it will effectively remove the prior constraints from consideration. For example, Posts.first.comments.unscoped will return ALL Comment's, not just those associated with the first Post. – Drew Dara-Abrams Sep 12 '13 at 20:34

add a comment |

asked	5 years, 4 months ago
viewed	13,873 times
active	5 years, 3 months ago

Remove order from ActiveRecord scope

2 Answers 2

Your Answer

Not the answer you're looking for? Browse other questions tagged ruby-on-rails activerecord ransack or ask your own question.

Hot Network Questions

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Not the answer you're looking for? Browse other questions tagged ruby-on-rails activerecord ransack or ask your own question.

Related