...
To view the properties for a trigger, select the trigger and the operations and trigger criteria display at the bottom of the window.
| Note |
|---|
When using a DATE field, the parameters must be encompassed between hash marks #. For example: [CREATDDT] > #2022-01-26 00:00:00#. |
Enabling a Trigger
- To edit the trigger properties, select an event trigger and then select Properties.
- In the Edit Event window, the General tab displays the General Settings and Operations. For Advanced Communication triggers, these fields are display-only and cannot be edited, except for the Trigger Enabled checkbox.
- Trigger Name: Indicates that any time a service call is created, this event will be active.
- Trigger Type: Displays a list of active CDC tables.
- Event ID: Displays the name of the Event ID.
- Operations: Indicates that any time something deleted, inserted, and/or updated in the CDC table view, the trigger will activate. Depending on the trigger type, additional choices are available in the Operations section.
- The Trigger Enabled checkbox indicates that the trigger is in use.
- Select OK.
...