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:
or by right-clicking on the entity in the repository tree and choosing Properties:
Choose the Business rules tab.
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.
- 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 to Inserting a Stored SQL Query and Storing a SQL Query for details.