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?
Thanks in advance and please excuse my poor English