Compound Filter Properties Dialog Box - Intergraph Smart 3D - Help

Intergraph Smart 3D Common

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Help
Version_S3D
10.1(2014R1)

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

Displays 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 PDS, Reference Files tab, and Reference 3D tab.

See Also

Create a new filter
Create a new filter folder
Select by Filter