[pilot-db-list] Re: Multiple "cumulative" filters

[Bryan M. <wb...@ja...>]

I can offer a couple of workarounds for getting the information you
want.

1. Run a sort on the database, sorting by "seen" then by "type"....
this will put all the unseen books together, followed by the unseen
films, then the unseen websites, with the seen items similarly organized
toward the bottom of the display.

2. Filter for the "type" you want, then run a sort on the results to
pop the unseen ones to the top of the list.

Sunday, October 5, 2003, 11:19:02 PM, you wrote:

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

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

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

pdlrlsn> --
pdlrlsn> Michael Graham
pdlrlsn> ma...@th...

-- 
 Bryan                            mailto:wb...@ya...