Opens when you select the Filter icon at the top of a column in the Engineering Data Editor. Allows you to specify filter criteria for the selected column to determine the display of items in the EDE.
When specifying three or more criteria, it is recommended that you avoid using complex combinations of And or Or operators to prevent unwanted results of the filtering.
Clear Filter
Clears all previously-defined filter settings and closes the dialog.
Search
Performs a search-as-you-type filter on column values for which any part of the column value matches the search string.
Select All
Click once to select all the check boxes beside the values shown for the column. Click again to clear all the check boxes (equivalent to canceling the filter on the column values). The check box displays a black square inside when only some of the column values are selected.
(Unique value check boxes)
Displays the distinct strings for all the values that appear in the column. If the column contains blank cells, these are indicated by the value [empty]. Select checkboxes beside the values to be included; clear the checkboxes beside the values to be excluded.
Show rows with value that
Allows you to specify additional filter criteria based on strings that comprise all or part of the data values. The criteria specified under Show rows with value that are additive with respect to the filtered values specified by the check boxes, that is, when both sections are used to define a filter, they make the filter more restrictive. These criteria might not work as expected for certain values of the Nominal Diameter property.
The available comparison operator options for columns whose data type is string or select list are as follows:
Is Equal To
Is Not Equal To
Is Less Than
Is Less Than Or Equal to
Is Greater Than
Is Greater Than Or Equal to
For data of string type only, the following additional comparison operator options are available:
Starts With
Ends With
Contains
Does Not Contain
When specifying several criteria, you can choose And or Or to specify the relationship between the criteria as follows:
And
Means both the current and succeeding criteria must be met.
Or
Means either the current or succeeding criteria must be met.
Add
Adds a row for a new criterion below the current criterion (not available for the first criterion row).
Delete
Deletes the entire row containing the criterion (not available for the first two criteria rows). Select the ‘x’ beside the string used to specify the value of the criterion to clear that value.
Filter
Displays the filtered results in the EDE.