This is an old revision of the document!
Table of Contents
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:
