In this section are presented the functions that are presented for all the process configurations that allow the use of formula.
▪PROCESS ID #: Returns the ID # of process instance (Workflow, Incident, Problem).
▪ATTRIBUTE VALUE: Returns attribute value. If it is a multivalued attribute, selected values will be separated with a comma.
Syntax:
|
ATTRIBUTEVALUE(<attribute ID #>)
|
▪STARTER: Returns the user who is the starter of the process. The <return> can be the "login", the "registration" or "user name".
Syntax:
|
STARTER(<return>)
|
▪REQUESTER: Returns the user requester of the process. The return can be the login, registration or user name.
Syntax:
|
REQUESTER(<return>)
|
▪QUANTITY OF EXECUTORS: Returns the quantity of executors of the same activity with multiple executors.
Syntax:
|
QUANTITYOFEXECUTORS(<order #>; <activity name>)
|
▪EXECUTOR: Returns the user who is the activity executor. The return can be the login, registration or user name.
Syntax:
|
EXECUTOR(<order #>; <activity name>; <return>)
|
▪ACTIVITY ACTUAL DURATION: Returns actual duration of activity in the elapsed time (since the activity was enabled to the execution date). The return can be in days, hours or minutes.
Syntax:
|
ACTIVITYDURATION(<order #>; <activity name>; <return>)
|
▪PROCESS ELAPSED TIME: Returns process elapsed time (from the start date to current date). The return can be in days, hours or minutes.
Syntax:
|
PROCESSELAPSEDTIME(<return>)
|
▪EXECUTED ACTION QUANTITY: Returns the quantity of times an action has been performed in the same activity executed by multiple executors.
Syntax:
|
EXECUTEDACTIONSQUANTITY(<order #>; <activity name>; <activity name>)
|
▪STARTER DEPARTMENT: Returns the ID # of the process starter department.
Syntax:
|
STARTERDEPARTMENT()
|
▪TABLE FIELD VALUE: Returns the value of a table field.
Syntax:
|
FIELDVALUE(<table ID #>; <field ID #>)
|
▪TABLE LIST VALUE: Returns the value of a table field.
Syntax:
|
LISTVALUE(<table ID #>; <relationship ID #>; <field ID #>)
|
▪EXECUTED ACTION: Returns name of action executed in the activity.
Syntax:
|
EXECUTEDACTION(<order #>; <activity name>)
|
▪EXECUTOR DEPARTMENT: Returns the ID # of the activity executor department.
Syntax:
|
EXECUTORDEPARTMENT(<order #>; <activity name>)
|
▪PRIORITY: Returns the priority.
Syntax:
|
PRIORITY(<name> or <order> or <value>)
|
▪PERCENTAGESTATUSSUBPROCESS: Returns the percentage of sub-process instances closed with a given status.
Syntax:
|
PERCENTAGESTATUSSUBPROCESS(<subprocess ID #>; <order #>; <status ID #>)
|
|