Special Actions - execute & Store Mysql Query 

Page / - last modified by Stefan Warnat on 2021/09/20 02:18 

execute & Store Mysql Query 
last modified by Stefan Warnat
on 2021/09/20 02:18

Table of Contents
Example

Only use this task if you could work with MySQL Querys!
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.
An equal result you could get with the function wf_dbquery inside custom expressions, which does exactly the same.
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”] …