Versions Compared

Old Version 1

changes.mady.by.user Betül Kara

Saved on

compared with

New Version Current

changes.mady.by.user Betül Kara

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Warning

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

Code Block
com.dooris.bpm.actionhandler.CallSqlFunctionHandler

Parameter

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}.

Info

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}

...