Transfer Status Trigger

The Transfer Status Trigger initiates a transfer when a value in the monitored table is marked as not yet transferred.

Once the transfer is complete, the record is marked as transferred or as failed. Failed transfers can optionally be retried any number of times using an additional counter.

note

For the transfer status trigger to work, the monitored table must have a primary key.

warning

Composite primary keys are not supported.

Properties

“General” tab

Term	Description
Data Source	Database plugin instance to be used.
Table	Table to be monitored.
Marker Column	Column in the table where the transfer status is stored. The column must be initialized with 0 or another configured value for “Not transferred.” It does not work with NULL.
Marker Values	Here you can define custom values for the various transfer statuses.
Retry Failed Transfers	If this option is enabled, failed transfers will be retried as many times as specified.
Number of Retry Attempts	Specifies how many times failed transfers should be retried.
Retry Column	Column in which the retries are counted. Note: The column must be initialized with 0. It does not work with NULL.
Retry delay	The amount of time to wait before retrying a transfer.
Sort order	Here you can set how the values should be sorted. If "None" is selected, no sorting is performed.
Sort column	The column by which to sort.
Limit number of records to	If this option is enabled, you can set the maximum number of records that can be transferred at once.
Do not use change notifications	If this option is enabled, the polling interval specified in the plugin is used for queries, even for databases with change notifications.

“Filter” tab

Here, filters and filter groups can be created and configured graphically. The SQL statement is constructed from the tree. Unlike with the DB transfer object, the filter values must be entered explicitly here.

Use the “Add” button to add filter criteria and the “Add Group” button to add filter groups. The button with the minus sign deletes the respective filter or filter group.

Filter

A filter consists of three elements:

• Column: The column to which the filter applies.
• Filter operator: The operator determines how the filter value is used to filter the records.
• Filter value: The value used to filter the records.

An explanation of the various filter operators can be found here.

“AND”/“OR”

Clicking on the text AND or OR changes the type of group to the other.

• AND means that all conditions in the group must be met for the group as a whole to apply.
• OR means that one condition in the group must be met for the group as a whole to apply.

“Columns” tab

Here you can select the columns whose values are to be used in the join. Columns can be selected or removed either by double-clicking or using the buttons to toggle between available and used columns.