Matching some but not all critiera

[v123]

I need a script that would create a found set consisting of all records that matched some, but not all, criteria. For instance, if a portal contains the years in which each salesperson met their quota between 2004 -2007, how can I find those salespersons that met their critera in three out of the four years?

[Phillip Holmes]

If the search is date based, and is done between years then you can do something like.

1. Create in your table a field that holds a 0 or 1 depending if the person meets the quota.

2. Create a calc field that sums the field from point number "1"

3.In your script set a variable to calculate how many years - In this case is 4.

4. Then omit records that the calc field = 4

that should leave you with what you want.