CRM – examples of selection expressionsIf you create a selection expression in the Selections (tdsmi0170m000) session, you use the Text Editor to create an expression. Examples of alphanumeric expressions
(R, contents) IN (10,100) (110,200) The value of the attribute must be greater than or equal to 10 and less than or equal to 100 OR greater than or equal to 110 and less than or equal to 200. Examples of string expressions
Examples
Alternative: (R,...) IN "abcde" Meaning: all attributes are checked for the presence of the string "abcde" Priority in expressions Arithmetic operators have a higher priority than relational operators. The latter have a higher priority than logical operators. The priority sequence for arithmetic operators is: * / ¥ + - The priority sequence for logical operators is: not and or Round brackets ("()") can be used to change the priority sequence for arithmetic and logical operators. For example, 3 + 4 * 5 = 23 and (3 + 4) * 5 = 35
| |||||||||||||||||||||||||