In addition to the basic filter options, there are two filter tools to help one customize the selection.  One is the (Custom…) option available from the main grid within the filter drop-down menu options.  This option invokes the Custom Filter dialog which is considered a basic filter.

 

Figure 25: Custom Filter option

 

This simple dialog allows a user to select a preset condition based on the data value chosen (“Type” in the example above).  An optional second condition can be placed, as well. 

 

TIP: Leaving the second condition blank will cause the logic to ignore it when filtering.

 

Wildcards can be used to broaden searches and they apply to the conditions of “like” and “not like” and they can be used to represent a single character (underscore mark) or a series of characters (percentage mark).  For example, to search for all values containing the word “claim”, a statement of “%claim%” can be used.  This search is not case-sensitive and will find all uppercase and lowercase matches.