Skip to main content

Workflow Test Functions

A test function performs data comparisons. Use a test function to identify the data type of a value, or determine if a value exists. You can use a test function on all Supported Data Types.

IsEmpty

IsEmpty(v): Tests if v is NULL or equal to "".

Example

Name (v)

IsEmpty

John

False

True

Mary

False

[Null]

True

IsInteger

IsInteger(v): Tests if (v) contains a value that can be converted to an integer. If so, it returns True.

Example

Value (v)

IsInteger

1

True

1.23

False

B

False

IsNull

IsNull(v): Tests if (v) is NULL. Returns True if v is NULL, otherwise returns False.

To populate a row with a NULL value, use the NULL() function .

Example

Name (v)

IsNull

John

False

[Null]

True

Mary

False

IsNumber

IsNumber(v): Tests if the field type for (v) is a number or not.

IsString

IsString(v): Tests if the field type for (v) is a string or not.