Differences

This shows you the differences between two versions of the page.

--- en:extensions:workflowdesigner:tasks:expert:mysqlquery [2014/10/15 09:16]
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 ======
+https://manuals.redoo-networks.com/wiki/manuals/view/Workflow%20Designer/Workflow%20Actions/Special%20Actions/execute%20%26%20Store%20Mysql%20Query/#
-<WRAP center round important 60%>
-Only use this task if you could work with MySQL Querys!
-</WRAP>
-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>