General Information‎ > ‎I/Gear‎ > ‎

Trigger e-mail from query that ONLY returns data.

posted Jun 27, 2011, 4:56 AM by Darren Ash   [ updated Jun 30, 2011, 11:52 AM ]
This would consist of a database query that executes and you want to email that data if records are returned.

For the database table, create a dummy field that is a calulated value (not stored) that always resolves to 1, in this case the field name is "Mail".

For the database datalink input command you create a query and map the data to datapoints that are bound to the columns.

For the trigger, set it to custom triggering and it would look similar to the following:

{SQL Server.GetNewAlarms.TriggerColumn}(0) = 1 AND {SQL Server.GetNewAlarms.TriggerColumn}.RAWDATA.REFRESH


See attached example.
Ċ
Darren Ash,
Jun 30, 2011, 10:44 AM
ċ
IGearTestDB.sql
(478k)
Darren Ash,
Jun 30, 2011, 11:52 AM
Comments