Ruby on Rails: How to sort a collection_select

Question

I want to sort / order it (desc or asc how i want it) by the database table column "plays" Im totally confused. Just found a solution for select but not collection_select?

some code of my view

<%= f.collection_select :player1, Player.all, :id, :name %>

dont know how to sort / order

there are also columns in the database table like "plays", "goals" ...

Hck · Accepted Answer · 2011-07-06 14:25:44Z

22

Just pass actually ordered collection to collection_select helper:

collection_select(:post, :author_id, Author.order('created_at DESC'), :id, :name_with_initial, :prompt => true)

So, in your source example it will look like this:

<%= f.collection_select :player1, Player.order('plays DESC'), :id, :name %>

edited Jul 6, 2011 at 14:25

answered Jul 6, 2011 at 12:52

Hck

9,2472 gold badges33 silver badges29 bronze badges

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

2 Comments

user753676 Over a year ago

dont know what you mean, am a newbie. could you change the code to my view so it will work and where to add this code by you? tried Player.all.order('created_at DESC') in the view but didnt work?

Wizard of Ogz Over a year ago

This is the right idea, but calling all executes the SQL query (which is why you can't call order afterward). You can simply move .all to the end of the chain or remove it completely since it is implied. <%= f.collection_select :player1, Player.order('plays DESC'), :id, :name %>

Collectives™ on Stack Overflow

Ruby on Rails: How to sort a collection_select

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related