Trigger e-mail from query that ONLY returns data.

Post date: Jun 27, 2011 11:56:44 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.