Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Business rule is a server-side script running at the moment of inserting, updating, or deleting a record. Business rules are used for such tasks as conditionally automatic value change in the form fields or event creation for email notifications and script actions.
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 rules run. Both execute after an action record start (insert
Image Added
Before Rules run conditions:
- After record action start (create, update, or delete).
- Before
- Before the system performs the server updates.
After rules Rules run condition:conditions:
- After record action start (create, update, or delete).
- After the system performs the server updates.
Info |
---|
For more information about execution order for before and after business rules, please refer to the Execution order article. |
Tip |
---|
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, select check the Abort Action checkbox 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
fieldsfields
Field | Mandatory | Description | |||||||
---|---|---|---|---|---|---|---|---|---|
Name | Y | Name a business rule. | |||||||
Table | Y | A table on which a business rule will be performing. | |||||||
Description | N | A brief action description. | |||||||
Set Value | N | Select a column of the table chosen in the Table field and define the needed value. | |||||||
Abort Action | N | Select this checkbox to interrupt When set to TRUE, and all conditions of a business rule are met then the transaction (update, insert, or delete) when all conditions are metwill be interrupted. | |||||||
Active | N | Select this checkbox to make the business rule activeWhen set to TRUE, a business rule will be performing; otherwise, it will not. | |||||||
Inheritance | N | Select this checkbox to apply this business rule to all child tables of the table defined in the Table fieldWhen 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 | N | Select this checkbox to display additional fields for complex business rules:
Note | | ||||||
When to Run tab | |||||||||
When | N | Defines the moment of a business rule execution:
| |||||||
Order | N | Defines the order of the business rule execution. If there are several business rules, they will perform in the ascending order.
| |||||||
Priority | N | Defines the importance of the business rule.
| |||||||
Action Insert | N | Select this checkbox to execute the business rule when inserting When set to TRUE, a business rule will perform the actions when inserting a new record. | |||||||
Action Update | N | Select this checkbox tp execute the When set to TRUE, a business rule will perform the actions when updating a record. | |||||||
Action Delete | N | Select this checkbox to execute the When set to TRUE, a business rule will perform the actions when deleting a record.
| |||||||
Filter Conditions | N | 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 Message | N | Select Check this checkbox box to display the Message text field if you want to show a message to a user when a business rule is performed. | |||||||
Message | N | Enter the message text you want to show to a user when a business rule is performed. | |||||||
Advanced tab Anchor | | advanced tab | advanced tab|||||||
Script | N | The action sequence that will be executed when a business rule is launched, previous and current variables are available:
When a record is inserted |
When a record is updated |
|
Table of Contents | ||||
---|---|---|---|---|
|