Merger Comparison List Filter Dialog - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

This dialog is used to filter the items that appear in the Merger Comparison List dialog.

(Filter condition display window)

Type the required filter criteria, or use the field list and operators to build a filter condition.

Field list

This data window displays all the available fields in the current source table. Double-click the required field that you want to include in your filter condition. The field name appears in the filter expression data window above.

Operators & functions

This dialog feature provides you with the built-in operators and functions described. Select the appropriate operator or function button to be added to the filter expression. The result is displayed in the filter expression data window above.

AND

Include the following expression in the filter combination. Example: (name <> '') AND (num <> 0)

OR

Accept either the previous or the following expression in the filter combination. Example: (loop = '') OR (line = '')

NOT

Select the value opposite to the following expression. Example: NOT (item_price = 0)

LIKE

Select a similar value that is similar to the one in the [value] field. You can use the following wildcard characters:

%

Any combination of characters.

_ (underscore)

Any single character

Example: cmpnt_num LIKE '%AA%'

IN

Select a value that is equal to one of those specified in the parentheses. Example: cpmnt_num = IN (101,103)

IS NULL

Contains an undefined value. (Select this option from the drop-down list and then right-click it to add it to the filter expression.) Example: loop_name IS NULL

IS NOT NULL

Not equal to NULL. (Select this option from the drop- down list and then right-click it to add it to the filter expression.) Example: cpmnt_name IS NOT NULL

BETWEEN

Select a value which is within the following interval. 

Example: item_price BETWEEN 100 AND 500

=

Equal to. 

Example: cpmnt_mfr = 'Shell'

>

Greater than; Example: cmpnt_num > 101

<

Less than; Example: item_price < 100

< >

Not equal to; Example: suffix <> 'AA'

>=

Greater or equal to.

Example: cmpnt_num >= 10

=<

Less than or equal to.

Example: item_price =< 30

SQL Functions drop-down list

This drop-down list contains special functions which are native to the source database. Select the required function from this drop-down list and then right-click it to be added to the filter expression.