| Info |
|---|
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. |
The scheme below illustrates when Before and After rules run.
Before Rules run conditions:
- After record action start (create, update, or delete).
- Before the system performs the server updates.
After Rules run conditions:
- After record action start (create, update, or delete).
- After the system performs the server updates.
| Notetip |
|---|
Role required: admin. |
Abort business rules
It is possible to perform business rules that terminate the follow-up actions and processes.
| Info |
|---|
The abort business rules terminate the following processes: Business rules, Notifications, Approval Rules, etc. See Approval Management to learn more about approval rule rejection. |
To make your business rule abort the follow-up processes, complete the steps below:
- Open a business rule desired;.
- On the form, check the Abort Action box;.
- Click Save or Save and Exit.
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 System Definitions → Business Rules.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Business rules form fields
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Name | Name a business rule. | ||||||
| Table | A table on which a business rule will be performing. | ||||||
| Description | A brief action description. | ||||||
| Set Value | Select a column of the table chosen in the Table field and define the needed value. | ||||||
| Execute Function | |||||||
| Abort actionAction | When set to TRUE, and all conditions of a business rule are met then the transaction (update, insert, or delete) will be interrupted. | ||||||
| Active | When set to TRUE, a business rule will be performing; otherwise, it will not. | ||||||
| Inheritance | When set to TRUE, a business rule will be applied not only for the table specified in the Table field but also for all its child tables. | ||||||
| Advanced | When set to TRUE, additional fields for configuration are displayed on the business rule form, including Script field. | ||||||
| Template | Use this setting to specify the field values of the Table records when performing a business rule on it. In the right field, choose a Table column and set the desired value in the left 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 several business rules, they will perform in the ascending order.
| ||||||
| Priority |
| ||||||
| Action Insert | When set to TRUE, a business rule will perform the actions when inserting a new record. | ||||||
| Action Update | When set to TRUE, a business rule will perform the actions when updating a record. | ||||||
| Action Delete | When set to TRUE, a business rule will perform the actions when deleting a record.
| ||||||
| Action Query |
| multiselect
| specifies the roles of users that must be met to perform a business rule
| ||||
| Filter Conditions | A condition builder that allows using static and dynamic filters. After specifying a table in the Table field, all fields of this table will be available in the constructor.
| ||||||
| Action tab | |||||||
| Add messageMessage | Check this box to display the Message text field if you want to show a message to a user when a business rule is performed. | ||||||
| Message | Enter the message text you want to show to a user when a business rule is performed. | ||||||
| Advanced tab | |||||||
| Condition | The condition option written using server-side API defines situations when a business rule runs. If this condition is met, then a Script will be executed. Use logical operators && (AND) and || (OR) for making up the complex conditional expressions. Condition option allows invoking server-side Script Includes created. | ||||||
| Script | The action sequence that will be executed when a business rule is launched, previous and current variables are available:
| ||||||
| Table of Contents | ||||
|---|---|---|---|---|
|