Logical functions

ISNULL / ESTNULL

Since Process17.0.0

Description

This function checks whether an object is null.

Syntaxe

1

@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.

1

@ISNULL(Approver)

ISEMPTY / ESTVIDE

Since Process17.0.0

Description

This function checks whether an object is empty.

Syntax

1

@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.

1

@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

1
2
3
4


@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
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”.

1

@COUNTIF(Order.values.Status;"equals";"Done")

Example 2 : returns the number of times the value 67 is present in a list.

1

@COUNTIF(ListField;"equals";67)

Example 3 : returns the number of times the value of another field is present in a list.

1

@COUNTIF(ListField;"equals";OterField)