Filters

 

Window Details

 

How Do I...

Navigation

 

Overview

 

Fields

     

 

Related Topics

   

Lookup FAQs

   

 

Navigation

In any lookup window, click Filters.

Overview

Use the Filters button  to enter additional criteria with which to filter the search. Filters that are defined in User Lookup Wizard will appear in the Filters window. If the filter is locked, it cannot be changed. If the filter is not locked, it can be removed or modified.

Note If filters are already defined, the text on this button appears red.

Each line item is a filter consisting of a column, operand, and value. You can enter an unlimited number of filters. If multiple filters are entered, they assume an "AND" condition (multiple values assume an "OR" condition). The Column drop-down list reflects all of the columns defined for the lookup, in addition to the <none> option. If <none> is selected in the Column drop-down list, the filter is removed from the list box. If a filter is removed, all filters appearing below the deleted filter move up one line.

Click Reset to clear all the filters entered and restore the filters from the custom lookup, if one exists. Clicking this button also clears the Save Filters check box.

Fields