Dynamic Filters with AJAX (like Redmine/Trac)

Rails
1

Hello G.s,

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:
Issues - Redmine.
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
OR
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:

–
Fernando B.