This dialog allows you to define a filter for use with macros that you add to a drawing sheet in the Enhanced Report Utility. You configure the macro filter data by setting the filtering conditions.
When defining a macro property (Oracle database only), you need to add an additional statement "or <property> is null" to your <property> like value.
For example:
Property |
Operator |
Value |
Logic |
Panel Name |
like |
%DCS% |
Or |
Panel Name |
null |
Filter for
Select from the list the item in the selected loop for which you want to define a filter, for example, Panel, Cable, Cable Set.
Filter
Select the required filter defined for the selected item in the Item Filters dialog. To open the Item Filters dialog to allow you to add, modify, or delete a filter, select the ellipsis button beside the list.
Description
Provides a read-only view of the description for the filter that you selected in the Item Filters dialog.
Display browser list
Allows you to display the Browser column in the data window if you want to select another browser in the case that a property that you want to use for the filter definition does not appear.
Clearing this check box hides the Browser column and displays the properties of the selected browser only.
Definition
Browser
Allows you to select the required browser for the selected item that includes the fields by which the data is to be filtered. If you cannot see this column, select the Display browser list check box.
Property
Allows you to select the required field from the list of fields available for the selected browser.
Operator
Allows you to select the required operator to determine how the selected field will relate to the chosen value.
Value
Allows you to type or select the required value to link it to the selected field by means of an operator.
Logic
Contains AND / OR expressions you can use to define the required logical relation between several filtering conditions.
Verify
Verifies the correctness of the entire filtering expression.
Reset
Resets the filter data.