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 

Default value

Description

Valid examples

Parameter 

Default value

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}