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.