User Tools
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
en:software:tim:actionhandler:callsqlfunction [2018/06/12 14:50] Stefan Barth |
en:software:tim:actionhandler:callsqlfunction [2019/09/19 21:37] (current) wikiadmin |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| <note important>This handler is outdated. Please use [[en:software:tim:actionhandler:runsqlscripthandler|runSqlScriptHandler]].</note> | <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 |}} | ||
| - | ---- | ||
en/software/tim/actionhandler/callsqlfunction.1528815035.txt.gz · Last modified: 2018/06/12 14:50 by Stefan Barth
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
