Rails how to sort mulitple columns using where?

Question

How do I order an instance variable using two columns?

I want to order after reel_order and reel_online which as a boolean and should be true.

I have tried this:

<% @movies.find(:all, :order => "reel_order, where(reel_online) = 1").each do |movie| %>

Is it possiable what activerecord or how to order this when using MySQL as database. I also want to know how to do it with a postgreSQL database.

UPDATE:

I am using this in my loop:

<% @movies.find(:all, :order => "reel_order, reel_online DESC").each do |movie| %>

enter image description here

The result is that the @movie is not ordered after reel_online. The reel_online is true when the eye is open. I want the open eyes to be at the top as expected.

You want to sort by reel_order with a secondary sort on the boolean result of the reel_online = 1 expression? — mu is too short
– mu is too short, Commented Oct 14, 2011 at 0:44
I wrote whole answer before i noticed. You want to sort by reel_online and choose only records where reel_online is TRUE? It make no sense to me. Sorting make sense only when you have more than one possible values. When you limit to those which are true, you have only one possible value of that column — Mailo Světel
– Mailo Světel, Commented Oct 14, 2011 at 12:07

emrass · Accepted Answer · 2011-10-14 11:52:35Z

4

I think you mixed the order of the columns. It should be

<% @movies.find(:all, :order => "reel_online DESC, reel_order").each do |movie| %>

answered Oct 14, 2011 at 11:52

emrass

6,4944 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rails beginner Over a year ago

the first column gets ordered last ?

emrass Over a year ago

No, it gets ordered first. So with your previous statement, you order by reel_order first, and among these items by reel_online. If you have 5 movies with reel_order = 1, those with reel_online will come first. If you have another movie with reel_order = 2 and reel_online = 1, this will come afterwards. You want it the other way round: Order by reel_online (putting those with reel_online = 1 first) and as second order criteria by reel_order.

Jordan Running · Accepted Answer · 2011-10-14 01:07:50Z

1

This ought to do it:

@movies.order("reel_order, reel_online DESC")

answered Oct 14, 2011 at 1:07

Jordan Running

107k18 gold badges193 silver badges189 bronze badges

1 Comment

bricker Over a year ago

@Jordan show us the relevant query being generated from the console output, please.

Mailo Světel · Accepted Answer · 2011-10-14 12:02:28Z

1

Igor Kapkov has similar aproach as me, but would me more active active record

@movies = Movies.find_all_by_reel_online(  1,
                                           :order => 'reel_order ASC, reel_online ASC'
                                           :conditions => ['reel_online = TRUE']
)

Documentation of find method http://apidock.com/rails/ActiveRecord/Base/find/class

Few database searches of mine https://github.com/roolo/mwstt/blob/master/app/controllers/datetimes_controller.rb

BTW: The <% leads me you are selecting the records in view. You should not put it in here

answered Oct 14, 2011 at 12:02

Mailo Světel

26.5k5 gold badges32 silver badges40 bronze badges

Collectives™ on Stack Overflow

Rails how to sort mulitple columns using where?

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related