Select and collect with conditions in Ruby on Rails

Posted on 12 April 2006

I really needed an option collection for a select box with confitions. In my case it needed to list vacancies people could apply for, but only if the vacancy was currently open. i.e. Check if it published or not?

I achieved it via this:

<%= f.select :vacancy_id, Vacancy.find(:all, :order => 'title', :conditions => ["publish = ?", 1]).collect { |v| [ v.title, v.id ] } %>

I even threw in an :order to sort the output by the vacancy title.

View the snippets archive ››