Table

This topic describes how to steer tables with Tosca Cloud.

Use the following action modes to steer columns, rows and cells in tables:

Action Mode	Value	Description
Input	<value>	Entering a value
Verify	<value>, <property>	Verifying a value or a property
Constraint	<value>	This restricts the search
Buffer	<buffer name>, <property>-><buffer name>	Buffer the value of a cell, row, or column.
Exclude	{TableCompare}	This excludes rows and columns from the baseline comparison.

Use the action mode Select to select the table.

Spaces, tabs and line breaks will be ignored during value comparisons if the action mode Constraint is used in a table.

For cells, you can only use the action mode Input with the value CLICK. To use any other Input value for cells, you have to create embedded controls.

In addition to the general properties, you can verify the following properties:

Property	Description	Available for
ColumnCount	Number of columns in the table.	table
RowCount	Number of rows in the table.	table
ColumnNumber	Index of the selected column. The value for a header column is 0 and the index for the remaining columns is relative to this column.	column
RowNumber	Index of the selected row. The value for a header row is 0 and the index for the remaining rows is relative to this row.	row
RawColumnNumber	Index of the selected column. It always starts at 1.	column
RawRowNumber	Index of the selected row. It always starts at 1.	row
ResultCount	Number of cells in a table which contain the content (constraint) you specify. Note the following: This property ignores cells that you have configured as headers in your table. If you want to include matching headers as part of the result count, reconfigure the headers of your table accordingly. The table control must use action mode Select. The cell which contains the content you want to look for in the table must use action mode Constraint. To limit the result count to the cells of a specific row or column, use action mode Verify in the row or column that contains the cell with the content you search for. Note that if you don’t specify a value for <Col> or <Row>, Tosca Cloud scans the entire table for the Value you specified in the respective <Cell> of the table.	row, column

Table structure

The Table control consists of <Col> and <Row> attributes. Each row or column may contain several <Cell> attributes.

Rows, columns and cells must be specified by using the name of the corresponding attribute. By doing so, the attribute name will be modified. Values in cells are specified via the Value column.

The following options are available for identifying cells:


Table attribute	Description
Baseline	Indicates that the table control contains a baseline.
<Row>	Possible values for identifying rows: <Row name>: a name that you define with the header. $1: steers the first row of the table. $<Row position>: steers the specified row of the table. $header: steers the header of the table. $last: steers the last row of the table. $header: steers a cell in the table header. $lastContentRow: steers the last table row which includes a value. $firstEmptyRow: steers the first table row which does not include a value. Specify the cell value in the Value column. The prefix $ steers a row in relation to its header. To steer a row based on its absolute position in a table, use the prefix #.
<Col>	Possible values for identifying columns: <Column name>: a name that you define with the header. $1: steers the first column of the table. $<Column position>: steers the specified column of the table. $last: steers the last column of the table. Specify the cell value in the Value column. The prefix $ steers a column in relation to its header. To steer a row based on its absolute position in a table, use the prefix #.
<Cell>	Possible values for identifying cells that are available within a row or column attribute: <Column or row name>: a name that you define with the header. $1: steers the first cell of the table. $<Cell Position>: steers the specified cell of a row or column. $last: steers the last cell of the row or column. $header: steers a cell in the table header. $lastContentRow: steers the last table row which includes a value. $firstEmptyRow: steers the first table row which does not include a value. Specify the cell value in the Value column. The prefix $ steers a cell in relation to a header. To steer a cell based on its absolute position in a row or column, use the prefix #.

Defining headers

Table controls contain the following steering parameters: HeaderColumn and HeaderRow.Tosca Cloud automatically identifies and copies them to the module as a technical ID. The value of these properties specifies the row or column to be used as a header. The header is steered by specifying the value $header.

Columns that are located before the specified header or column are steered by using negative row or column numbers.

The table below includes examples that illustrate how to steer the according cell via row and column numbers:


$-2, $-2					$-2, $3
	$-1, $-1		$-1, $1
	$header, $-1	$header	$header, $1	$header, $2
			$1, $1	$1, $2
$2, $-2
					$3, $3

FirstEmpty and LastContent commands do not work for columns or rows that are located beyond the defined header row or column.

Defining the value range of cells

Tosca Cloud copies cell values to the module as a value range of the parameter ExplicitName. These names are the input values for steering,You can select them from the drop-down menu of column, row or cell TestStepSubValues.

You can use date and time expressions, regular expressions and random values for defining the values.

Defining Decisive Columns

Some columns may contain entirely standard data such as currency or date values. Cells of these columns however need not contain any relevant data. Columns which contain crucial data are referred to as Decisive Columns in Tosca Cloud.

The system can read rows that are filled with concrete values.

Use the parameter DecisiveColumns of a table attribute to define one or more decisive columns. Several values are specified by separating them with semicolons.