Criteria for ‘LP_ID MAPPED_TO LP_ID’ - Intergraph Smart Materials - Version 2020 (10.0) - Administration & Configuration - Hexagon PPM

Intergraph Smart Materials Classic Administration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
2020 (10.0)

If your rule based where condition is defined based on mappings ‘LP_ID MAPPED_TO LP_ID’, you can use the lower right section of the Rules tab to select attributes and values to limit the selected idents based on list position attribute values.

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 the 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 SQ wildcard matching. You can use _ (underscore) as a

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.