Filter list results

Rails
1

Hey All,

What’s the right way to make a list of something (games in my case)
but filtered by various parameters? For example, I have /game/list
showing all games, but if they specify /game/list/?
category=3&players=5 I want to show all games in that category that
allow 5 players.

Right now, I can get the category’s games by using

  if defined? params[:category]
    @games = Category.find(params[:category]).games;
  end

and I can get the players by using

  if params[:players].to_i > 0
    @games = Game.find(:all, :conditions => ['players = ?',

params[:players]]);
end

But how can I do both?

2

Any Ideas? I know how to do it with a straight SQL Query, but I’m not
sure if there is a more ruby-like way

3

Straight SQL isn’t bad for this kind of stuff… @games =
Game.find_by_sql("select *…)

But there are other ways too. Conditions can be built up
programatically…

See Ben Curtis’ well-written article on this approach:

http://www.bencurtis.com/archives/2008/06/restful-searching-in-rails/

Or you could use something like ez_where

http://opensvn.csie.org/ezra/rails/plugins/dev/ez_where/README.txt

4

Thanks for the help!