Compound Filter Properties Dialog - Intergraph Smart 3D - Help

Intergraph Smart 3D Common

Language
English
Product
Intergraph Smart 3D
Subproduct
Common
Search by Category
Help
Smart 3D Version
13.1

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.

SHARED Tip 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.

SHARED Tip 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.

See Also

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