Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:extensions:workflowdesigner:tasks:expert:mysqlquery [2014/01/05 12:23] swarnat [Mysql Query] |
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 an example Organization Workflow, which will execute two simple queries and save one result into the description field and the other into a new comment. | + | |
- | [[http://support.stefanwarnat.de/_media/en:extensions:workflowdesigner:mysqlquery.bin|Download Example]] | + | |
- | </WRAP> | + |