[pilot-db-list] Multiple "cumulative" Filters

[Michael G. <ma...@th...>]

I'm just playing around with the filter feature - very powerful feature!

It would be nice to be able to apply more than one filter at
a time.  Maybe have an 'AND' mode for filters, where each filter you
select is applied in addition to the previous ones.  This continues until
you select 'No Filter'.  This would be a great and easy way of narrowing
the record set.

For instance, I'm building a 'recommendations' database, where I track
films, books, and websites that friends suggest to me.  There's a 'type'
field (i.e. film/book/website) and a boolean 'seen' field.  If I want to
see a list of all unseen movies, currently I have to create a filter
script for that purpose:

  (and(%0 seq Movies)(eq(int %1)0))

Then I have to make similar scripts for 'unseen books', 'unseen
websites', etc.

Note also that this script (with spaces removed) is exactly equal to the
maximum script length limit for filter scripts, so I'll have trouble
when it comes to 'websites'.


Thanks,


Michael

--
Michael Graham
ma...@th...