View Source

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:
WhereScape 3D 9.0.3.0 > Entering Business Rules for an Entity > Entering Business Rules for an Entity.png
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.
WhereScape 3D 9.0.3.0 > Entering Business Rules for an Entity > 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.

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.