=========CallSqlFunction========
==== Description ====
<note important>This handler is outdated. Please use [[en:software:tim:actionhandler:runsqlscripthandler|runSqlScriptHandler]].</note>

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 ====
<code>
com.dooris.bpm.actionhandler.CallSqlFunctionHandler
</code>
\\
----
==== 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:\\
{{ :software:tim:actionhandler:callsqlfunctionhandler1.png }}
\\
\\
DecisionHandler:\\
{{ :software:tim:actionhandler:callsqlfunctionhandler2.png |}}
----