Picker filters

Picker filters provide a way for users to refine the viewable results of a secondary search. Data values applied in picker filter fields are applied in addition to the default criteria defined for the secondary search.

Picker filters are always enabled and appear as a single row of grid cells above the picker’s row of column titles. Picker filtering is supported on text and number data types. The picker filter cell will not be accessible for the following data types:

• Column values transformed for display to a localization format or precision (e.g., Date, date/time, duration and decimal values)
• Columns stored as a codified value and translated to a text string for display (i.e., Enumerated and Boolean data types)

To apply a picker filter, type a value into a quick filter cell and either hit the ‘Enter’ key, or click on the Filter icon. The picker list will be refreshed to display rows matching your picker filter criteria.

Picker filters do not support special characters for multiple selection, wildcards, exclusion, etc. The value entered into a picker filter cell is applied as an ‘and contains’ condition atop the search criteria defined for the secondary search. For example, if ‘A’ is applied as a filter in the Carrier ID column of a picker list, any Carrier containing the letter ‘A’ anywhere in its Carrier ID field will be returned.

To remove a picker filter, highlight the specific value you wish to remove from picker filter, and use the ‘Backspace’ key to remove the highlighted value. Repeat this for each picker filter value to be removed, then use ‘Enter’ (or click on the Filter icon). The picker list will be refreshed to display entries that meet the secondary search criteria, plus any picker filter criteria that may remain.