User Tools

Site Tools


Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
This translation is older than the original page and might be outdated. See what has changed.
en:software:tim:actionhandler:callsqlfunction

CallSqlFunction

Description

This handler is outdated. Please use runSqlScriptHandler.

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:


en/software/tim/actionhandler/callsqlfunction.txt · Last modified: 2021/07/01 09:52 (external edit)