CallSqlFunction (outdated)

This handler is outdated. Please use RunSqlScriptHandler.

Description

This handler can be used as an ActionHandler 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 specified.

DecisionHandler
If the handler is placed on an XOR, it uses user-defined parameters to call a MySQL function, which has been stored in the database and decides which way to go based on the return value.
If the result is null, a default transition can be specified.

Class

com.dooris.bpm.actionhandler.CallSqlFunctionHandler

Parameter

Parameter	Description	Valid examples
functionName	Name of the MySQL function. This may also contain a process variable.	`returnEmployeeData`
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}. The order of the parameters must match the order of the function parameter	`${employeeID}`
resultName	Name of the variable to which the returned value is written. A process variable may be given for this, i.e. ${REPLACEME}	`employeeData`
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}	`${noDataAvailable}`

CallSqlFunction (outdated)

Description

Class

Parameter

functionName

params

resultName

defaultTransition