Data Types and Operators

Conditions are expressed in FEEL language and must be written in that language.

Decision Table supports the following data types.

Click the types to get more information

String

• String expressions must be written in quotation marks.
• Strings are case-sensitive

==	Used when the condition is expected to be equal.
!=	Used when the condition is expected to be not equal.
IS IN	Used when the value of the variable is expected to provide any of the ordered data.
IS NOT IN	Used when the value of the variable is not expected to provide any of the ordered data.

Example of using “IS IN” and “IS NOT IN”

Number

• Must be written without quotation marks

==	Used when the condition is expected to be equal.
!=	Used when the condition is expected to be not equal.
<	Used for checking if the value of input variable is greater than the value in the process.
>	Used for checking if the value of input variable is less than the value in the process.
>=	Used for checking if the value of input variable is less than or equal to the value in the process.
<=	Used for checking if the value of input variable is greater than or equal to the value in the process.
IS IN	Used when the value of the variable is expected to provide any of the ordered data.
IS NOT IN	Used when the value of the variable is not expected to provide any of the ordered data.

Boolean

==	Used when the condition is expected to be equal.
!=	Used when the condition is expected to be not equal.

Date

• Date values has no time zone offset and interpreted as UTC time zone.
• Date data type has also provides a context of sequence of numbers for the year, month, day of month.

==	Used when the condition is expected to be equal.
!=	Used when the condition is expected to be not equal.
<	Used for checking if the value of input variable is greater than the value in the process.
>	Used for checking if the value of input variable is less than the value in the process.
>=	Used for checking if the value of input variable is less than or equal to the value in the process.
<=	Used for checking if the value of input variable is greater than or equal to the value in the process.
IS IN	Used when the value of the variable is expected to provide any of the ordered data.
IS NOT IN	Used when the value of the variable is not expected to provide any of the ordered data.

Collection

• A collection data type is a complex type that is made up of one or more elements, all of the same data type.

ANY OF	Used when the condition is expected to contain one of the data in it.
NONE OF	Used when the condition is expected to contain none of the data in it.
ALL OF	Used when the condition is expected to contain all.
NOT ALL OF	Used when the condition is not expected to be exactly the same.
==	Used when the condition is expected to be equal. It checks that the whole structure is equal, including its order.
=!	Used when the condition is expected to be not equal. It checks that the whole structure is not equal, including its order.

Example of using Collection

“Collection” Variable Value	Outputs
{9,5}	b,d
{5,9}	b,d,e
{2,7}	a,b