Logical functions
ISNULL / ESTNULL
Since Process17.0.0
Description
This function checks whether an object is null.
Syntaxe
@ISNULL(object)The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| object | Any Java object of type java.lang.Object. | Yes |
return value
Function ISNULL returns @TRUE if the object is null, otherwise it returns @FALSE.
Examples
Example 1 : Verify that the Approver field is not null.
@ISNULL(Approver)ISEMPTY / ESTVIDE
Since Process17.0.0
Description
This function checks whether an object is empty.
Syntax
@ISEMPTY(object)The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| object | Only the types java.lang.Object and java.util.Collection are supported. | Yes |
return value
Function ISEMPTY returns @TRUE if the object is null, otherwise it returns @FALSE.
Examples
Example 1 : Verify that the Approver field is not empty.
@ISEMPTY(Approver)COUNTIF / NB.SI
Since Process17.0.0
Description
This function returns the number of times a criteria is met in a list of values from a list field or table column.
Syntax
@COUNTIF([ListField], "[operator]", [texte value])
@COUNTIF([ListField], "[operator]", [number value])
@COUNTIF([TableField].values.[Column], "[operator]", [texte value])
@COUNTIF([TableField].values.[Column], "[operator]", [number value])The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| list | List of numbers or list of strings. | Oui | |
| operator | operator to use. For numbers: “equals”, “notEquals”, “greaterThan”, “greaterOrEquals”, “lowerThan”, “lowerOrEquals”. For strings: “contains”, “equals”, “notEquals”. |
Yes | |
| Compare_value | Comparison value. This can be a number or text from a field, for example. | Yes |
return value
The function COUNTIF returns the number of elements that meet the specified criteria.
Examples
Example 1 : returns the number of lines whose column is equal to the fixed value: “Done”.
@COUNTIF(Order.values.Status;"equals";"Done")Example 2 : returns the number of times the value 67 is present in a list.
@COUNTIF(ListField;"equals";67)Example 3 : returns the number of times the value of another field is present in a list.
@COUNTIF(ListField;"equals";OterField)