This is an old revision of the document!

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.

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 a example Organization Workflow, which will execute two simple queries and save field into the description field and the other into a new comment.
Download Example