RoboFlowHelp.1.19

!!! warning "Legacy Documentation" This page contains documentation for the original RoboFlow application. Some features described here may not exist in the new Damtoolkit WAP interface.

WatchSQL (Process results of an SQL query)

Watchsql workflow launches an SQL query in every time-loop. The results of the query are sql-records, which are processed one by one.

The field-values of an SQL-record can be access by using this inline-scripting instruction: #SQLFIELD(hot;myfield)#

For every sql-record a Cumulus query can be performed and its records processed. The record is available on the TAG (variable name) “hot”

Functionality can be added for each sql-record in the Action Script for SQL Records and for each record in Action Scripts for Records.

An e-mail can be sent for every Cumulus record or SQL-record if no cumulus records are processed.

(Email-messages are bundled per e-mail-address)

If "CumulusCatalog" is left empty, no Cumulus records are processed.

NOTE: Before using this workflow, you will have to install the JDBC driver for your SQL-database and modify the wrapper.conf file to include the path to the jar of the JDBC-driver.

Parameters

SQLdatabase

SQL-connect-string

e.g. jdbc:mysql://localhost/default?user=xls&password=xls

SQLdriver

The java-class of the jdbc-driver to use

e.g. com.mysql.jdbc.Driver

SQLquery

The sql-statement to exectute before every loop

e.g. select * from myTable where (status = 'offline')

CumulusCatalog

The name of the Catalog you want to watch. (if left empty, no Cumulus records are processed)

 type in the name or click on the button to connect and select a catalog

CumulusQuery

The Cumulus record query. For details on the syntax of the query see Cumulus Query Syntax.

e.g. ("ProductID" == "#SQLFIELD(hot;myProductID)#")

EmailNotify

E-mail-address of person to notify for every record being processed (multiple e-mail-addresses separated by ;)

E-mail-Message-Configuration

Parameterfile for the e-mail subject, body and message