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”] …