This dialog allows you to filter the target fields in the Import Comparison List dialog.
To access this dialog, select Filter in the Import Comparison List dialog.
Filter expression
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 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. |
Tag Number LIKE '%AA%' |
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 target 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
This button is not available in this dialog.
Verify
This button is not available in this dialog.