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.