Entering Business Rules for an Entity

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

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 REPLACE WITH THIS IMAGE: Images/Common_Icons/open_sql.png next to the respective query editor field. They can also be stored by clicking the respective Store SQL query button REPLACE WITH THIS IMAGE: Images/Common_Icons/saveicon.png . Refer to Inserting a Stored SQL Query and Storing a SQL Query for details.