Configure Value Area (Checkpoint Properties Dialog Box) - Table/Database Checkpoints

Relevant for: GUI tests and scripted GUI components

For a table checkpoint (in the Table Content Tab) and a database checkpoint, this area displays three tabs:

Note: For a table checkpoint, the Properties tab also displays the Configure Value area, For details, see Configure Value Area.

Expected Data Tab

Note: When more than one cell is selected (highlighted) in the grid area, the options in the Expected Data tab are unavailable.

User interface elements are described below:

UI Element	Description
Selected cell	Indicates the table name and the row and column numbers of the selected cell.
Configure value	Enables you to set the expected value of the cell as a constant or parameter. For details on modifying values, see Configure Value Area.
	Constant Value Options/Parameter Options. Opens the Constant Value Options or Parameter Options dialog boxes to edit the value for a constant value, or select a different parameter type or modify the parameter settings for a parameter value. When editing a constant value, you can define string or complex value as a regular expression.

UI Element

Description

Selected cell

Indicates the table name and the row and column numbers of the selected cell.

Configure value

Enables you to set the expected value of the cell as a constant or parameter. For details on modifying values, see Configure Value Area.

Constant Value Options/Parameter Options. Opens the Constant Value Options or Parameter Options dialog boxes to edit the value for a constant value, or select a different parameter type or modify the parameter settings for a parameter value.

When editing a constant value, you can define string or complex value as a regular expression.

Settings Tab

Note:

The settings in this tab apply to all cells marked for verification.
The default setting is to treat cell values as strings and to check for the exact text, while ignoring spaces.

User interface elements are described below:

Option	Description
Verification type	Specifies how cell contents are compared: String Content. (Default) Evaluates the content of the cell as a string. For example, 2 and 2.00 are not recognized as the same string. Numeric Content. Evaluates the content of the cell according to numeric values. For example, 2 and 2.00 are recognized as the same number. Numeric Range. Compares the content of the cell against a numeric range, where the minimum and maximum values are any real number that you specify. This comparison differs from string and numeric content verification in that the table data is compared against the range that you defined and not against a specific expected value.
Exact match	(Default) Checks that the exact text, and no other text, is displayed in the cell. Clear this checkbox if you want to check that a value is displayed in a cell as part of the contents of the cell. Available only when String Content is selected as the Verification type.
Ignore space	(Default) Ignores spaces in the captured content when performing the check. The presence or absence of spaces does not affect the outcome of the check. Available only when String Content is selected as the Verification type.
Match case	Conducts a case sensitive search. Available only when String Content is selected as the Verification type.
Min / Max	Specifies the numeric range against which the content of the cell is compared. The range values can be any real number. Available only when Numeric Range is selected as the Verification type.

Cell Identification Tab

Note: The settings in this tab apply to all cells marked for verification.

User interface elements are described below:

UI Element	Description
Identify columns	Specifies the location of the column (in your actual table) containing the cell(s) to which you want to compare the expected data. By position. (Default) Locates cells according to the column position. A shift in the position of the columns within the table results in a mismatch. By column name. Locates cells according to the column name. A shift in the position of the columns within the table does not result in a mismatch. (Enabled only when the table contains more than one column.)
Identify rows	Specifies the location of the row (in your actual table) containing the cell(s) to which you want to compare the expected data. By row number. (Default) Locates cells according to the row position. A shift in the position of any of the rows within the table results in a mismatch. By selected key column(s). Locates the row(s) containing the cells to be checked by matching the value of the cell whose column was previously selected as a key column. A shift in the position of the row(s) does not result in a mismatch. If more than one row is identified, OpenText Functional Testing checks the first matching row. You can use more than one key column to uniquely identify any row. Note: A key symbol is displayed in the header of selected key columns.
Use value match criteria to identify data in the key column	Instructs OpenText Functional Testing to use the verification type settings from the Settings tab as the criteria for identifying data in the key column. Enabled only when you select to identify rows By selected key column(s).

UI Element

Description

Identify columns

Specifies the location of the column (in your actual table) containing the cell(s) to which you want to compare the expected data.

By position. (Default) Locates cells according to the column position. A shift in the position of the columns within the table results in a mismatch.
By column name. Locates cells according to the column name. A shift in the position of the columns within the table does not result in a mismatch. (Enabled only when the table contains more than one column.)

Identify rows

Specifies the location of the row (in your actual table) containing the cell(s) to which you want to compare the expected data.

By row number. (Default) Locates cells according to the row position. A shift in the position of any of the rows within the table results in a mismatch.
By selected key column(s). Locates the row(s) containing the cells to be checked by matching the value of the cell whose column was previously selected as a key column. A shift in the position of the row(s) does not result in a mismatch. If more than one row is identified, OpenText Functional Testing checks the first matching row. You can use more than one key column to uniquely identify any row.

Note: A key symbol is displayed in the header of selected key columns.

Use value match criteria to identify data in the key column

Instructs OpenText Functional Testing to use the verification type settings from the Settings tab as the criteria for identifying data in the key column.

Enabled only when you select to identify rows By selected key column(s).