Remove order from ActiveRecord scope

ruby-on-rails activerecord ransack
jrhicks picture jrhicks · Feb 29, 2012 · Viewed 25.6k times · Source

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

Answer

Mori picture Mori · Feb 29, 2012

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

Article.order('headline asc').to_sql
# "SELECT `articles`.* FROM `articles`  ORDER BY headline asc"
Article.order('headline asc').reorder('').to_sql
# "SELECT `articles`.* FROM `articles` "

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails: select unique values from a column

I already have a working solution, but I would really like to know why this doesn't work: ratings = Model.select(:rating).uniq ratings.each { |r| puts r.rating } It selects, but don't print unique values, it prints all values, including …

Read More
Rails: How do I create a default value for attributes in Rails activerecord's model?

I want to create a default value for an attribute by defining it in ActiveRecord. By default everytime the record is created, I want to have a default value for attribute :status. I tried to do this: class Task < …

Read More