Rule specification functions
The rule specification asset includes a range of functions that you can use in rule logic in basic and advanced modes.
You can use the following functions in basic and advanced modes:
- •ABS
- •ADD_TO_DATE
- •ASCII
- •CEIL
- •CHOOSE
- •CHR
- •CHRCODE
- •CONCAT
- •CONTAINS
- •CONVERT_BASE
- •COS
- •COSH
- •CRC32
- •CUME
- •CURDATE
- •DATE_COMPARE
- •DATE_DIFF
- •DATECONVERT
- •DECODE
- •EXP
- •FLOOR
- •FV
- •GET_DATE_PART
- •GREATEST
- •IFF
- •IN
- •INDEXOF
- •INITCAP
- •INSTR
- •IS_DATE
- •IS_NUMBER
- •IS_SPACES
- •ISNULL
- •LAST_DAY
- •LEAST
- •LEFTSTR
- •LENGTH
- •LN
- •LOG
- •LOWER
- •LPAD
- •LTRIM
- •MAKE_DATE_TIME
- •MD5
- •METAPHONE
- •MOD
- •MONTHCOMPARE
- •MOVINGAVG
- •MOVINGSUM
- •NPER
- •PMT
- •POWER
- •PV
- •RAND
- •RATE
- •REG_EXTRACT
- •REG_MATCH
- •REG_REPLACE
- •REPLACECHR
- •REPLACESTR
- •REVERSE
- •RIGHTSTR
- •ROUND
- •RPAD
- •RTRIM
- •SET_DATE_PART
- •SIGN
- •SIN
- •SINH
- •SOUNDEX
- •SQRT
- •SUBSTR
- •SYSTIMESTAMP
- •TAN
- •TANH
- •TIMECOMPARE
- •TO_CHAR
- •TO_DATE
- •TO_DECIMAL
- •TO_FLOAT
- •TO_INTEGER
- •TRUNC
- •UPPER
- •XOR
You can use the following functions in advanced mode only: