Criteria for ‘IDENT MAPPED_TO IDENT’ - Intergraph Smart Materials - Version 10.2 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.2

If your rule based where condition is defined based on mappings ‘IDENT MAPPED_TO IDENT’, you can use the lower left section of the Rules tab to select attributes and values for the ‘Attribute based’ commodity codes of your where condition.

If the selected attribute has a Derived_From or valid values assigned on A.50.01 Attributes, an LOV for selecting the value is available. Manually inserted values will be checked against the predefined LOV.

For combining attributes and values, the operators listed below are available.

Operator

Description

=

<>

<

<=

>

>=

These operators perform comparisons.

Examples:

ATTR = 'XA' -> matches only values equal to XA

ATTR <= 5 -> matches any value less than or equal 5

BETWEEN

NOT BETWEEN

For these operators, you must define a range as a comparison value.

Example:

ATTR BETWEEN 2 AND 4 -> matches any values greater than 2 and less than 4

ATTR NOT BETWEEN 10 AND 50 -> matches any values less than 10 and greater 50

LIKE

NOT LIKE

These operators perform SQL wildcard matching. You can use _ (underscore) as

placeholder for exactly one character, or % (percent) to match any combination

of characters.

Examples:

ATTR LIKE 'X%' matches any value beginning with X.

ATTR LIKE 'B_M' matches any three character value beginning with B and having M as the third character.

ATTR NOT LIKE ‘A%’ matches any value not beginning with A.

IN

When using this operator, you must define a list of values to be included in the selection as the corresponding value.

Example:

ATTR IN ('XX', 'YY', 'ZZ') -> will only fetch records with the assigned values ‘XX’, ‘YY’, or ‘ZZ’.

NOT IN

When using this operator, you must define a list of values to be excluded from the selection as the corresponding value.

Example:

ATTR NOT IN ('AB', 'AC', 'AD') -> will only fetch records not having the values ‘AB’, ‘AC’, or ‘AD’ assigned.

IS

This operator checks for empty fields. You must define either NULL or NOT NULL as the corresponding value.

Example:

ATTR IS NOT NULL

For values of type VARCHAR2, do not forget the quotes and parentheses.