Window Details |
How Do I... |
|||
|
|
|||
|
|
|||
|
Related Topics |
|||
|
|
Lookup FAQs |
|
|
In any lookup window, click Filters.
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.
© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks