Specify an Insertion Condition - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

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

You can specify an insertion condition for every selected source table. This way you instruct the Merger Utility to insert every selected source row of the selected source table, which complies with the table’s insertion condition. Note that the insertion condition affects only the source tables that you have selected to be merged.

The insertion condition can contain any combination of the following:

  • Source columns

  • Operators or functions

  • Alphanumeric values

The insertion condition affects only the source tables which you have selected to be merged.

  1. On the Advanced Selection dialog, select the check box under the Insert Only column for the selected table.

    • Use the horizontal scroll bar to display the pertinent section of the dialog.

    • Selecting the check box under the Insert Only column causes the Merger Utility to insert any source rows (of the selected source table) which comply with the condition specified in the adjacent Condition column.

  2. Under the Condition column, type the appropriate insertion condition.

Make sure you type the appropriate condition, as this will affect the merge process results.

The Merger Utility provides you with the following inherent operators and functions.

Operator / Function

Descriptions

Example

=

Equal to

cpmnt_mfr = 'Shell'

>

Greater than

cmpnt_name > '101'

<

Less than

item_price < 100

>=

Greater or equal to

num >= 10

=<

Less than or equal to

item_price =< 30

<>

Not equal to

prefix <> 'AA'

AND

Include the following expression in the filter combination

name AND num <> 0

OR

Accept either the previous or the following expression in the filter combination

Loop OR line = ''

NOT

Select the value opposite to the following expression

NOT (item_price = 0)

LIKE

Select a value that is similar to the one in the ‘%[value]%’ field

cmpnt_name LIKE '%AA%'

IN

Select a value that is equal to one of those specified in the parentheses

cpmnt_name = IN ('101','103'

BETWEEN

Select a value which is within the following interval

item_price BETWEEN 100 AND 500

IS NULL

Equal to NULL

Loop IS NULL

IS NOT NULL

Not equal to NULL

line IS NOT NULL

SHARED Tip The above operators and functions are those used in the WHERE string of the SQL statement.

When a table is defined on a specified level, it contains data which is unique on that specified level. For example, the CABLE Table is defined per area. Therefore, the CABLE Table contains data that is unique only on the area level of the domain.