Page History
To enter a business rule on an entity, select the Properties screen for that entity, either by right-clicking on the entity in the diagram and choosing Properties:
REPLACE WITH THIS IMAGE: Images/Business Rules Validation/Entering Business Rules for an Entity.png
or by right-clicking on the entity in the repository tree and choosing Properties:
REPLACE WITH THIS IMAGE: Images/Business Rules Validation/Entering Business Rules for an Entity_1.png
Choose the Business rules tab.
REPLACE WITH THIS IMAGE: Images/Business Rules Validation/Entering Business Rules for an Entity_2.png
Icons | Description |
---|
Click to Add a business rule. |
Click to Edit the selected business rule. |
Click to make a Copy of the selected business rule. |
Click to Delete the selected business rule. |
In the right pane, enter the details for the business rule. Click OK.
REPLACE WITH THIS IMAGE: Images/Business Rules Validation/Entering Business Rules for an Entity_4.png
- The Validation code is a SELECT statement that is run to gather data for validating the business rule. It should only return one row, otherwise only the first row returned will be used.
- The Expected results are the expected values for the attributes in the row returned by executing the validation code. Each expected result has a name, which is also the name of the attribute being checked, and the expected value for that attribute, which may also be an expression such as value > 3.
- The Drill down code is a SELECT statement used to show more detail on the business rule data so you can look into why expected and actual results differ.
Note | ||
---|---|---|
| ||
You can use stored queries for validation code and/or the drill down code by clicking |
...
the Insert Stored SQL Query |
...
button next to the respective query editor field. They can also be stored by clicking the |
...
respective Store SQL query |
...
button . Refer |
...
...
...
for details. |