DB Trigger - Configuration (Magic xpi 4.13)
The DB Trigger component lets Magic xpi continuously monitor the triggers created for the events defined in the DB Trigger service. Before you use the DB Trigger component, a DB Trigger service must be configured in the Settings dialog box's Services section.
To configure the trigger, double-click or right-click on the trigger and select Configuration from the context menu to open the DB Trigger Configuration dialog box.
This dialog box contains the following fields:
|
|
|
|
Service Name
|
The name of the service that the user defined in the Settings dialog box's Services section. This field is read-only.
|
|
Trigger Event
|
Select an event from the drop-down list. The drop-down list is populated with the events added for the DB Trigger service. Click here, for more information.
|
|
The Trigger Event can be selected only once across the whole project.
|
|
|
Event Details
|
Event details is the read-only list of tables' names added as part of the selected event. The list will also show status of the Create, Update and Delete event for each database table.
|
|
Return Table Name
|
Click  (ellipsis button) to open the Variable List. Select a variable to set the table name for which the trigger event is fired.
|
|
Return Action Type
|
Click (ellipsis button) to open the Variable List. Select a variable to set Action type, either of Create, Update or Delete, for which the trigger event is fired.
|
|
Return Payload
|
Click (ellipsis button) to open the Variable List. Select a variable to set the payload returned by the trigger event.
|
|
Polling Interval (In Minutes)
|
Set the polling interval to poll the trigger events from the database. The TriggerAction table will be polled at the specified interval.
|
|
Tip:
|
The trigger events will be sent sequentially to the flow. For linear flow execution, the Max Instance property of the flow should be set to 1.
|
