| # CRM – examples of selection expressions If you create a selection expression in the Selections (tdsmi0170m000) session, you use the Text Editor to create an expression. Examples of alphanumeric expressions
(R, color) = "red" | attribute is alphanumeric
tccom100.bpid = "JOHNSON" | table field is alphanumeric
(R, contents) = 1 | attribute is numeric
tccom110.umsp = 2 | table field is numeric
(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
^ | beginning of the string
$ | end of the string
. | any character
* | 0 or more times the previous character
() | one of the characters between (), e.g. (abcd123) or (a-z)
(^) | any sign other than, e.g. (^XYZ0-9)
"" | double quote within a string
Examples "abcdefg" IN "def" = TRUE "abcdefg" IN "^def$" = FALSE "abcdefg" IN "^a" = TRUE "abcdefg" IN "^b" = FALSE "abcdefg" IN "g$" = TRUE 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 Related topics CRM – Text Editor CRM – overview |