|
|
Dynamic Filtering Part 2 - Matching Many Possible Values
Proto makes it easy to create a filter in which a column must match (or not match) any one of a set of values. Some example uses of this functionality are:
-
Selecting multiple salespeople, product IDs, regions, etc. from a Listbox control or other interface, and filtering an Entryset to use only rows pertaining to the selected salespeople, products, regions, etc.
-
Allowing users to keep a list of items to exclude from processing, such as incorrect records which could not be deleted from a source database. Then use a filter of the form "the order ID is NOT equal to any of [the dynamic list of IDs]."
-
Use any other process, including another filter, to produce a single column Entryset that sets the comparison values of a filter with the form "the XYZ attribute is equal to any of [the values in the single column Entryset provided]." For example, use the resulting rows from a drill down interface to filter a separate dataset, to show all Notes associated with the related rows of data.
The example shows an Entryset Filter in the three stages required to configure an "equal to any of" filter.
|
