|
|
The check fundamentals such as evaluation condition, data items filters, and multiple data items are important concepts to understand the process of creating a check. These values can be set in the Advanced Settings dialog box when you create a check.
See Create Check: Advanced Settings.
To understand these concepts, assume a fictitious scenario. Assume that there is a table named EXAMPLE in a database. This table can be considered equivalent to a category in an evaluation condition.
The table EXAMPLE contains the following fields and values:
CASE I: The following evaluation condition is set and no filter is applied on the evaluation condition:
|
Evaluation Condition |
In the table EXAMPLE, the value of the field A should be greater than 9. |
|
Equivalent field expression for the evaluation condition |
A > 9 |
|
Data items filter |
-- |
For the field A, three data values (9, 10, and 11) are present in the table. Each data value is tested against the specified evaluation condition and the following results are obtained:
To calculate the final result for the tested data, you must specify the action that should be taken for multiple data items.
If the AND operator is applied for the sample check, then the final result is as follows:
|
Final test result (Applying the All must meet the evaluation condition option) |
FAIL (FAIL AND PASS AND PASS) |
CASE II: The same evaluation condition is set and a data items filter that consist of a single filter statement is applied:
|
Evaluation Condition |
In the table EXAMPLE, the value of the field A should be greater than 9. |
|
Equivalent field expression for the evaluation condition |
A > 9 |
|
Evaluation condition filter |
D > 50 |
On applying the filter statement, only those values of the field A are tested that match the filter statement. In the example, now only the values 10 and 11 are checked against the evaluation condition.
The individual results for the tested data values are as follows:
If you now specify the action for multiple data items as "All must meet the evaluation condition", then the final result is as follows:
CASE III: The same evaluation condition is set and two filter statements are specified in the data items filter as follows:
In the CASE III, the following values are returned on applying each filter statement:
|
D > 50 |
The following values are returned: A = 10 A = 11 |
|
C = P |
The following values are returned: A = 9 |
When you apply more than one filter statement on the evaluation condition, you must specify the behavior for multiple filter statements. This behavior is used to determine the data items that would be considered for evaluation purpose.
You can select either of the following options to specify the behavior for multiple filter statements:
If you consider only the data items that match any one of the filter statements, then the final data values are obtained as follows:
|
Applying OR operator as follows: (A = 10) OR (A = 11) OR (A = 9) |
All the three data values are available for testing. A=9 A=10 A=11 |
You can then proceed to test each data item against the evaluation condition.