[pilot-db-list] Plans for filters?

[Greg A. <ga...@es...>]

I noticed that filters are mentioned on the TODO list.  Has work begun on
that yet?  If nobody else is working on it, I have some ideas for a system
that fits with the conventions used in DB, and I'm ready, willing, and
able to get to work on it.

What I envision is something like the different list views, where you can
create different filters each with a different name, and then you can
select one to perform that filter.  The default would be an empty filter
that just let's everything through.

When editing a filter, you would be presented with a screen very similar
to the sort screen.  Something like this:

    op cs Field value     Field
*   <  x  ____________  * field name


Clicking on the first * would give you a pulldown letting you insert
another filter line.  Clicking on the op field would give you a pulldown
letting you choose a filter operation (<, >, =, <=, >=).  The field name
would be chosen just as for Sorting, and the field value is the value to
perform the operation to filter against (so, <= for a date field would
select all records with the date field showing a date before or on the
specified date).  

Then, when you select that filter, each filter operation is essentially
ANDed together.

For now, filters could be selected the same way list views are now (go to
the display menu option and have pulldowns for both view and filter).
Later, support could be added for named reports that specify both a view
and a filter -- then you just click the report you want and it shows it
with one click.

Any comments, improvements, alternatives?

Greg