Constraint rules
Characteristic | Description |
---|---|
Definition | A constraint rule checks whether data is valid. Note: There is no real difference between a calculation rule and a constraint rule. Each offers different starting points in the Rule Wizard; the options on the Actions tab change depending on the rule type that you select. |
Study objects that can have constraint rules |
|
Programming experience necessary | Creating a constraint rule is comparable to writing formulas in the Microsoft Excel spreadsheet software. |
What to define | You must define:
|
Example (without a function) | A constraint rule determines if a calculated BMI value is below the expected value of 30. You create the rule on the form that contains the weight and height items. You provide the following information to create the rule:
The following information appears in the Rule Summary section: evaluate on Form Submission value = this.weight / (this.height)*(this.height) |
Example (with a function) | A constraint rule uses a function (_CalculateBMI) and determines if a calculated BMI value is below the expected value of 30. You create the rule on the form that contains the weight and height items. A programmer creates the function, and a non-programmer provides the following information to create the rule:
The following information appears in the Rule Summary section: evaluate on Form Submission You could create the rule without a function, as described in the previous example, or with a rule template. For more information, see Intrinsic rules. |
Copyright © 2013 Oracle and/or its affiliates. All rights reserved. |
---|