Builds a compound filter or views the properties of an existing filter. This dialog box appears when you click New Compound Filter on the Select Filter dialog box or when you select an existing compound filter and then click Properties on the Select Filter dialog box.
Compound filter name
Specifies a name for the new compound filter or displays the name for an existing compound filter.
Filter type
Specifies the category of filters, such as Catalog Filters.
Select filter to use in compound expression
Provides a tree view to select the existing filters in the Catalog Filters folder you want to use for building the compound filter.
Add to String
Places the filter name in the text box at the bottom of the Compound Filter Properties dialog box. To build the SQL statement with the operator buttons on the Compound Filter Properties dialog box, insert operators, such as a union, intersection, or the not operator, and parentheses for priorities in sequencing.
Properties
Reviews the properties of a filter. Select the filter name in the query statement and click Properties.
Or
Specifies or inserts the union operator at the location you indicate in the string in the text box.
And
Specifies or inserts the intersection operator at the location you indicate in the string in the text box.
Not
Inserts the not operator at the location you indicate in the string in the text box.
(
Specifies or inserts the left parenthesis, which starts a priority for the operators. The software inserts the parenthesis at the location you indicate in the string in the text box.
)
Specifies or inserts the right parenthesis, which ends a priority for the operators. The software inserts the parenthesis at the location you indicate in the string in the text box.
Place pointer in the text box where you want to add a filter name or operator
Instructs you to click the text box at the location to add a filter or SQL operator to the compound filter definition, and allows you to remove a filter or SQL operator from the compound filter definition.
To remove a filter or SQL operator from the compound filter definition, click the filter or SQL operator in the text box, and then click Delete or press Backspace.
Delete
Removes the selected filter or operator from the compound filter definition.
Clear All
Removes the object definition.
You are not required to use parentheses in a statement, but parentheses provide structure that is easier to follow, especially in a complex statement. Without the parentheses, an SQL statement follows a default order of operations. Specify Not operators first, followed by And operators and then the Or operators. For example, in the statement X And Y Or Not Z, the Not operator is processed first, followed by And and finally Or. To change this order, you must use parentheses.
Compounding is not supported on filters containing filtering criteria on Reference 3D tab.