### Check Advanced Settings

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.

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:

Table: EXAMPLE

A

B

C

D

9

X

P

50

10

Y

Q

60

11

Z

R

70

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:

 A = 9 Result = FAIL A = 10 Result = PASS A = 11 Result = PASS

To calculate the final result for the tested data, you must specify the action that should be taken for multiple data items.

You can select either of the following options to specify the action for multiple data items:

• All must meet the evaluation condition

The AND operator is applied on the individual results of each data item.

• At least one must meet the evaluation condition

The OR operator is applied on the individual results of each data item.

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:

 A = 10 Result = PASS A = 11 Result = PASS

If you now specify the action for multiple data items as "All must meet the evaluation condition", then the final result is as follows:

 Final test result (Applying the All must meet the evaluation condition option) PASS (PASS AND PASS)

CASE III: The same evaluation condition is set and two filter statements are specified in the data items filter as follows:

 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 Filter statement 1 D > 50 Filter statement 2 C = P

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:

• Return only the data which matches all of the filter statements.

The AND operator is applied on each data item.

• Return only the data which matches any one of the filter statements.

The OR operator is applied on each data item.

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.