Dynamic Filters with AJAX (like Redmine/Trac)

Hello Guys,

I have a model “Person” with lots of columns (date, int, string, so on) and right now I need to make a filter for my costumer.

My goal is something like this: http://www.redmine.org/projects/redmine/issues.

Or, even better: http://trac.edgewall.org/demo-0.12/query.

The most interesting feature for me is to be able to choose different columns and to have customized options (LIKE or NOT LIKE for strings, BETWEEN … and … for dates, and so on)

Unfortunately, Redmine only allows 1 criteria per database column.

Trac, on the other hand, accepts OR and AND, so I can make “complexes” searches, like:

something AND something AND something


something else AND something else

That said, my questions are:

  • Does anybody know anything (Gem, plugin or tutorial) that can help me on the backend or on the frontend? I am using jQuery and Rails 3.

  • Is the new ActiveRecord Query API on Rails 3 complete enough to make this in a DRY way or should I use a specific Gem for searching (eg. searchlogic)?

  • Is there any opensource Rails project with such a complete filter like Trac?

  • Should I try to release it as a Gem when its done? :smiley:

Thanks in advance and please excuse my poor English :stuck_out_tongue: