CASE ER function
The CASE function evaluates the value of the specified expression against the specified alternative options and returns the result of the first option that equals the value of the specified expression. Otherwise, it returns the optional default result, if a default result is specified as the last argument of the called function that isn't preceded by an option. The value that is returned can be a value of any of the supported data types.
Syntax
CASE (expression, option 1, result 1[, option 2, result 2, …, option N, result N, default result])
Arguments
expression: Primitive data type (Boolean, numeric, or text)
A valid expression that returns a value of the primitive data type.
option 1: Primitive data type (Boolean, numeric, or text)
A valid expression that returns a value of the same primitive data type as the expression argument of the called function. This argument is required.
result 1: Any of the supported data types
The returned result that corresponds to the preceding option. This argument is required.
option N: Primitive data type (Boolean, numeric, or text)
A valid expression that returns a value of the same primitive data type as the expression argument of the called function. This argument is optional.
result N: Any of the supported data types
The returned result that corresponds to the preceding option. This argument is optional.
default result: Any of the supported data types
The result that should be returned if there is no match. This argument is optional.
Return values
Any of the supported data types
The resulting value of any of the supported data types.
Usage notes
An exception is thrown at runtime if there is no match and an optional default result isn't defined.
All results must be specified by using the same data type. An exception is thrown at design time if the data types of the configured results don't match.
If the first result value and the Nth result value are values of the Container (record) or Record list data type, the result has only the fields that exist in both values.
Example
CASE( DATETIMEFORMAT( NOW(), "MM"), "10", "WINTER", "11", "WINTER", "12", "WINTER", "") returns the string "WINTER" if the current application session date is between October and December. Otherwise, it returns a blank string.