Make select list output in alphabetical order in Rails?

Question

I have a select list in my model which lists a persons name with their employers name:

<li>Case Handler Name<span><%= f.select :person_id, Person.all.collect { |x| [x.name_and_company, x.id] } %></span></li>  

def name_and_company
return "#{personname} (#{company})"
end

Is it possible to force the select list to output in alphabetical order?

I am assuming I would put an order tag in there...somewhere?

(:order => 'personname DESC')

Thanks,

Danny

Answer 1

You can do it like this

# controller
@people = Person.order_by('personname ASC').collect {|x| [x.name_and_company, x.id] }

# model
named_scope :order_by, lambda { |o| {:order => o} }  

# view
<%= f.select :person_id, @people %>

Answer 2

Answer:

    #users_controller.rb
    def index
      @people = Person.alphabetically
    end

    #user.rb
    scope :alphabetically, order("name ASC")

    #index.haml
    = f.select :person_id, @people.all.collect { |p| [p.name, p.id] } %>