Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:extensions:workflowdesigner:tasks:expert:mysqlquery [2014/01/05 12:23] swarnat created |
en:extensions:workflowdesigner:tasks:expert:mysqlquery [2021/09/20 00:18] (current) swarnat |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{ :en:extensions:workflowdesigner:tasks:expert:task_mysqlquery.png?nolink|}} | + | ====== execute & Store Mysql Query ====== |
| - | ====== Mysql Query ====== | + | https://manuals.redoo-networks.com/wiki/manuals/view/Workflow%20Designer/Workflow%20Actions/Special%20Actions/execute%20%26%20Store%20Mysql%20Query/# |
| - | + | ||
| - | + | ||
| - | This task executes a query against the database and save the first row of the result into an environmental variable, which could be used by other tasks. | + | |
| - | + | ||
| - | <WRAP info> | + | |
| - | ==== Example ==== | + | |
| - | You execute a query which get a row with the columns "colA", "colB", "colC", "colD" and you save this to the environmental variable //mysqlresult//. | + | |
| - | You could use these values by $env["mysqlresult"]["colA"] or $env["mysqlresult"]["colB"] ... | + | |
| - | + | ||
| - | Here you get a example Organization Workflow, which will execute two simple queries and save field into the description field and the other into a new comment. | + | |
| - | [[http://support.stefanwarnat.de/_media/en:extensions:workflowdesigner:mysqlquery.bin|Download Example]] | + | |
| - | </WRAP> | + | |