Business-rule is a server-side script running at when the moment when inserting, updating or deleting a record.
Use them for such tasks as conditionally automatic value change in the form fields or event creation for email notifies and script actions.
Business-rules can use scenarios to perform actions with records in the database. Even so, there are several other options of the script actions available, such as client-side scripts and UI-actions.
Business-rules creation
You can create business-rule that will be running when inserting, updating or deleting a record.
To create it, please perform the following steps:
- Navigate to the System Definitions -> Business Rules;
- Press New;
- Fill in the form fields and save the business-rule.
Form Filling Description
| Field | Description |
| Name | Business-rule name, |
| Table | A table on which the business-rule will be performing. |
| Description | Brief actions description. |
| Abort action | If TRUE and all conditions of business-rule are met then the transaction (update, insert, delete) will be interrupted. |
| Active | If TRUE then this business-rule will be performing; otherwise it will not. |
| Inheritance | If TRUE then this business-rule will be applied not only for the table specified in the Table field but also for all its child tables. |
| Advanced | If TRUE then additional fields for configuration are displayed on the business-rule form, including Script field. |
| When to Run tab | |
| When | Defines the moment of a business-rule execution:
|
| Order | Defines the order of the business-rule execution. If there are over one business-rules, they will perform in the ascending order. |
| Action Insert | If TRUE then this business-rule will perform when inserting a new record. |
| Action Update | If TRUE then this business-rule will perform when updating a record. |
| Action Delete | If TRUE then this business-rule will perform when deleting a record. |
| Filter Conditions | Business-rule launch condition constructor. After specifying a table in the Table field, all fields of this table will be available in the constructor. |
| Advanced tab | |
| Script | The action sequence that will be executed when the business-rule is launched, Variables previous and current are available in the function: previous – the state of the record field before saving. This variable is not available to use in Action Insert business-rules; current – record fields values that will be saved. |
