Database trigger

The database trigger monitors query results and triggers the transfer on change. The trigger defines a select query. If the result of this query changes, the trigger triggers a transfer.

Database Trigger

The individual properties are:

DB-Connection	The configured instances of the DB plug-in are available here.

Tab General (all types)

Table	Table being monitored. Note: The specified table must have a primary key. Tables without a primary key are not supported.
Available columns	All available columns that have not yet been selected for the panel “Used fields”. Select the columns to monitor.
Used fields	All already selected fields. Use the arrows between “Available columns” and “Used fields” to add or remove fields.
Triggern at OPC Router start	At router start it will be trigger.

Tab: Filter (Select, Update, Delete)

Filter	Displays filters and filter groups graphically. The SQL statement is constructed from this tree at runtime. You must enter the values ​​here, unlike the DB transfer object. Use the buttons to add filter criteria (“Add filter”) and grouped filter criteria (“Add filter group”) to individual filter criteria. “Delete” deletes the selected criterion. Important: The filter set here must clearly specify a data record in the “table”, which is then monitored.
Edit filter	The possible entries change depending on which element is selected at “Filter”. Column: Column to filter on. Relational operator for the comparison of values. Value, after being filtered.
Preview	Preview the SQL statement.