The system events allow you to create tasks for server-side script execution, or notification sending at a specified point in time. These are the most common use cases of system events. You can also use one event register for the needs listed above.
Role required: admin.
To use the system events in your tasks, complete the following steps:
- Create an event register record.
- Define a server script for a system event by creating a record in the Event Script Actions (sys_event_script_action) table.
- Define a notification rule to send notifications.
- You can combine the options listed above so that the event register record triggers actions and sends notifications at the same time.
Event structure
Create an event
To create an event, use the server-side API methods ss.eventQueue or ss.eventQueueScheduled. Create an event as described in the referenced articles. As a result, new records in the Event (sys_event) table will be created.
You cannot create, edit, or delete records in the Events (sys_event) table manually. Only users with the admin role can read them.
To read event records, navigate to System Events → Events.
Event form fields
Field | Description |
|---|---|
Name | The name of the record called from the Event Register (sys_event_register) table. |
Instance | The ID of the record object. When creating an event with the ss.eventQueue or ss.eventQueueScheduled method, pass on the Record object. The object ID will be saved in this field. Call this value in the Event Script Action (sys_event_script_action) script body:
|
Table | A reference to the record table that was passed when the event was created. This field is populated automatically. |
Process started at | The date and time when the system event execution started. As for the scheduled events, this field is populated with the value passed by the parameter of the ss.eventQueueScheduled method. The date and time of the Event (sys_event) script execution. |
Process finished on | The date and time when the system event execution finished. |
Param1-5 | The string parameters that can be passed to the specified Event (sys_event) record via the SimpleOne server-side API (ss.eventQueue and ss.eventQueueScheduled methods). The maximum length of a string parameter is 4000 symbols. All symbols above this limit are cut in the Event record. The data of the record from which the string parameters were passed is not changed. |
State | The event state:
|
Processing duration, ms | The duration of the system event processing in milliseconds. |
User | This field is populated with the system user (which can also be displayed as 100000000000000000 on the forms). The system executes the script on behalf of this user. |
Related lists are bound with the event record and contain the following records:
- The list of all related event register records from the Event Register (sys_event_register) table.
- The list of all the scripts from the Event Script Action (sys_event_script_action) table that have references to the current record.
Event Register
To create an event register, complete the following steps:
Navigate to System Events → Event Registers.
- Click New and fill in the fields.
- Click Save or Save and exit to apply the changes.
Event Register form fields
Field | Mandatory | Description |
|---|---|---|
Name | Y | Specify the name of the event register. The Event (sys_event) record of this register contains this value in its Name field. Name is the first parameter of the eventQueue method. |
| Table | Y | Specify the table that contains records related to the events. To trigger email sending with this record, ensure that the value in the Table field in the Notification Rule record is the same as in this event register record. |
| Description | N | Add a description for the event register record. |
| Disable script logging | N | Select the checkbox to disable script execution logging to the Script Logs (sys_log_script) table when the related event begins. |
The Related Lists area bound with the event register record contains the following records:
- A list of all the scripts from the Event Script Action (sys_event_script_action) table that have references to the current record.
- A list of all Notification Rules triggered by the record of the current event register.
Event Script Action
To create an event register, complete the following steps:
Navigate to System Events → Event Scripts.
- Click New and fill in the fields.
- Click Save or Save and exit to apply the changes.
Field | Description |
|---|---|
Name | Specify the name of the event script action. |
Event Register Record | The reference to the record in the Event Register (sys_event_register) table. |
| Active | Select this checkbox to activate the script. |
Script | Specify the script that is executed when the event occurs. In the Event Script Action, the event object is available. The object is the instance of the SimpleRecord class and refers to a record from the Event (sys_event) table that initiated the script. To get the values of the record fields, use the dot-notation for the event object. To do so, use properties with the names corresponding to the names of the record fields. For example: const currentRecord = new SimpleRecord(event.table_id.name);
currentRecord.get(event.instance);
if (String(currentRecord.state) !== event.param_1) {
currentRecord.state = event.param_1;
currentRecord.update();
}
You can also update the parameters (Param1-5) of the event object with the Event Script Action. Script example (function executeEventScript(event) {
const lastComment = new SimpleRecord('sys_activity_feed_item');
lastComment.addQuery('table_id', '156950677111866258'); // itsm_incident
lastComment.addQuery('record_id', event.instance);
lastComment.addQuery('type_id.name', '!=', 'history');
lastComment.orderByDesc('sys_created_at');
lastComment.setLimit(1);
lastComment.query();
event.param_5 = lastComment.next();
})(event);
|
