Events allow executing server-side scripts at some point of time or a specific schedule.
Every script executing event consists of:
- the script body (stored in the sys_event_script_action table);
- the register record which the script (or the scripts) refers to;
- the event record that calls the register record (the linked script is executed as a result)
The event structure:
Role required: admin.
How to create an event
To create an event, add a new record into the sys_event table. For this, please complete the following steps:
- Navigate to System Definition -> Events
- Click New, fill in the form and then click Save.
You can find the fields described below on this page.
Also, the event can be created via server-side API methods ss.eventQueue or ss.eventQueueScheduled.
Event Record
Field | Description |
|---|---|
Name | The name of the record called from the sys_event_register table. |
Instance | The ID of the Record object. When creating an event via calling methods ss.eventQueue or ss.eventQueueScheduled, you can pass on the Record object. The object ID will be saved in this field. You'll be able to call on this value in the sys_event_script_action script body: event.instance |
Table | The table that contains the record specified in the Instance field. |
Process on | The date and time of the sys_event_script_action script execution. |
Processed | The date and time when the event has been done. |
Param_1...Param_ 5 | The string parameters. The values of them are callable in the sys_event_script_action script: event.param_1, event.param_2, and so on. |
State | Event state:
|
Processing duration ms | The sys_event_script_action script processing duration in milliseconds. |
User | The event originator. |
The Related List on the form event contains the list of all scripts from the sys_event_script_action table, that will be executed (or has been executed).
Event Register Record
Field | Description |
|---|---|
Name | The name of the register record on which the script will be referenced to and which will be used to call an event in the event record. |
| Table | Starts only those events that contain a record related to a specified table. |
The Related List on the form event contains the list of all scripts from the sys_event_script_action table that are referenced to the current record.
Event Script Action Record
Field | Description |
|---|---|
Name | The name of the event script action. |
Event Register Record | The reference to the record in the sys_event_register table. |
Script | The script executed at the event call. Five additional string parameters (Param_1 ... Param_5) are choosable in the script body, so you can call their value in this way: event.param_1, event.param_2; You can also address to other field values of the following record: event.column_name Events are the objects of the sys_event table, so any fields can be addressed, as well as through the dot-walking feature. |
