StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You should post the controller method also, to better understand the model.</p> <p>Anyway, assuming that the model Something has a string "category" column, you should not hardcode the values for the select, unless these values are fixed, in which case you might consider not using a string column.</p> <p>Here's a fast-typed example:</p> <pre><code># something_controller.rb def index @categories = Something.find_by_sql("SELECT category FROM somethings GROUP BY category").map &:category @somethings = params[:category].blank? ? Something.all : Something.find_all_by_category(params[:category]) end </code></pre> <p>this is the view:</p> <pre><code><% form_tag(:action => :index) do %> <%= select_tag "category", options_for_select(@categories) %> <%= submit_tag "Filter" %> <% end %> <table> <tr> <th>foo</th> ... </tr> <% somethings.each do |something| %> <tr> <td><%= something.foo %></td> ... </tr> <% end %> </table> </code></pre> <p><strong>Update:</strong></p> <p>While the above code works, it was really too fastcoded, and suggests bad practise.</p> <p>Here's a better way:</p> <pre><code># app/models/Something.rb def self.all_categories find_by_sql("SELECT category FROM somethings GROUP BY category").map(&:category).select {|x| x} end def self.select(category) if category find_all_by_category(category) else find :all end end #app/controllers/something_controller.rb def index @categories = Something.all_categories @somethings = Something.select(params[:category]) end </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload