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/10/15 09:14] swarnat |
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 ====== | ====== execute & Store 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. | + | |
- | + | ||
- | This feature also create a the function "wf_dbquery" inside custom expressions, which does exactly the same. (See [[en:extensions:workflowdesigner:custom-functions|custom expressions]] page for documentation) | + | |
- | + | ||
- | <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]] | + | |
- | Also the new function "wf_dbquery" is included in this example, which create a second comment with the CRMID and type of the latest record. | + | |
- | </WRAP> | + |