execute & Store Mysql Query
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”] …