This page is not fully translated, yet. Please help completing the translation.
(remove this paragraph once the translation is finished)

CallSqlFunction

Description

This handler can be utilized as an action handler or a decision handler!
ActionHandler:
Uses user-defined parameters to call a MySQL function, which has been stored in the database. The returned value is then written into a process variable.
If the result is null, a default value can be supplied.

DecisionHandler:
If the handler is placed on an XOR, it uses user-defined parameters to call a MySQL function from the database. The resulting value is then used to determine the method for further processing.
If the result is null, a default transition can be supplied.

Action Class

com.dooris.bpm.actionhandler.CallSqlFunctionHandler

Event Type

any

Action Name

any

Mandatory Fields

none

Parameter

functionName

Name of the MySQL function. This may also contain a process variable, i.e. ${functionName}.

params

The parameters to be passed to the MySQL function.
Any number of variables may be passed; these are separated by dashes (“-”).
Process variables may also be passed, i.e.: ${param1}-${param2}-${param3}.
CAUTION: The order of the parameters must match the order of the function parameter (See example)!

resultName

Name of the variable to which the returned value is written.
A process variable may be given for this, i.e. ${REPLACEME}

defaultTransition

Decisionhandler:
IF the returned value is null, the process will continue along this path.
A process variable may be given for this, i.e. ${REPLACEME}
ActionHandler:
If the returned value is null, the received value will be set as a variable.
A process variable may be given for this, i.e. ${REPLACEME}

Example

ActionHandler:
DecisionHandler: