Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Business-rule is a server-side script running at when the moment when inserting, updating, or deleting a record.them for such tasks as conditionally automatic value change in the form fields or event creation for email notifies 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.

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:

  1. Navigate to System Definitions -> Business Rules;
  2. Click New;
  3. Fill in the form fields and save the business-rule.


Note

Role required: admin.

Business rules form fields

FieldDescription
NameThe business-rule name,
TableA table on which the business-rule will be performing.
DescriptionThe brief action description.
Abort actionWhen set to TRUE, and all conditions of business-rule are met then the transaction (update, insert, delete) will be interrupted.
ActiveWhen set to TRUE, this business-rule will be performing; otherwise it will not.
InheritanceWhen set to TRUE, this business-rule will be applied not only for the table specified in the Table field but also for all its child tables.
AdvancedWhen set to TRUE, 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:

  • before – execution prior to the operation of the business-rule launch trigger (prior to the updating, inserting or deleting a record);
  • after – execution after to the operation of the business-rule launch trigger (after the updating, inserting or deleting a record);
OrderDefines the order of the business-rule execution. If there are over one business-rules, they will perform in the ascending order.
Action InsertWhen set to TRUE, this business-rule will perform the actions when inserting a new record.
Action UpdateWhen set to TRUE, this business-rule will perform the actions when updating a record.
Action DeleteWhen set to TRUE, this business-rule will perform the actions when deleting a record.
Filter ConditionsBusiness-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.




Table of Contents
absoluteUrltrue
classfixedPosition