Import Source 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 allows you to define a filter condition to import selective data.

To access this dialog, on the Source tab of the Link Properties dialog, select Use filter and then select Modify.

Filter Expression Data Window

The data window displays the filter expression. You can type the expression in this data window or select the appropriate Operator and Function buttons to set the filter condition.

Source table columns

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 will appear in the filter expression data window above.

Operators and functions

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. The following table lists the built-in operators and functions available to you when defining the filter settings:

Operator/Function

Description

Example

AND

Include the expression that follows in the filter combination.

(name <> '') AND (num <>0)

OR

Accept either the previous expression or the expression that follows in the filter combination.

(loop = '') OR (line = '')

NOT

Select the value opposite to the expression that follows.

NOT (item_price = 0)

LIKE (value)

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.

Tag Number LIKE '%AA%'
Process Function Name LIKE P_

IN

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

cpmnt_num = IN (101,103)

IS NULL

Contains an undefined value. (Select this option from the list and then right-click it to be added to the filter expression.)

loop_name IS NULL

IS NOT NULL

Contains a defined value. (Select this option from the list and then right-click it to be added to the filter expression.)

cpmnt_name IS NOT NULL

BETWEEN

Select an alphanumeric value which is within the specified interval.

item_price BETWEEN 100 AND 500

=

Equal to

Manufacturer = "Shell"

>

Greater than

Tag Number > 101

<

Less than

Process Function Name < 'P'

>=

Greater or equal to

Velocity >= 10

<=

Less than or equal to

Low Alarm <= 30

<>

Not equal to

Loop Suffix <> AA

SQL Functions list

This list contains special functions which are native to the source database. Select the required function from this list and then right-click it to be added to the filter expression. For details about most common functions and their descriptions, see SQL Functions Native to Source Database.

View Source

Displays the contents of the source table or database file that you selected.

Verify

Verifies the correctness of the filter expression displayed in the data window.