Get Total Row Count

This is a pre-built Action located under the captured grid element. The functionality of this action in Avo Assure is to retrieve the total number of rows present in the grid based. The result is stored in the given dynamic variable for further use during test execution

Syntax

Input Value: <header/body>(optional);<left/right>(optional);<visible>(optional)

Argument	Description
<header/body> (optional)	<header/body> (Optional) Provide the section of the table from which the row count is taken. header: Counts rows in the grid header (header;left/right). body: Counts rows in the grid body (body;left/right).
<left/right> (optional)	<left/right> (Optional) Specify whether to count rows in the left fixed or right fixed section of the grid. left: Counts only the columns fixed on the left side. right: Counts only the columns fixed on the right side.
<visible> (optional)	Provide the text visible in the input value to count only the total rows of the current page of the specified grid. Note: The input text is case sensitive.
N/A	If the input is not specified, it provides the total row count from all pages of the grid.

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the rows count of grid.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example 1: Retrieving the Total Number of Rows in a Grid

In this example, we explain how to retrieve the total number of rows present in the captured table or grid.

• Action: Get Total Row Count

• Input Value: N/A

  • This action does not require any input value, as it automatically reads the structure of the captured table or grid.

• Output Value: {Count}

  • The total number of rows in the grid (100) is stored in the {Count} dynamic variable.

  • If a second output variable is provided, the action status is stored in the {Status} variable, with the following possible values:

    • True: If the row count is retrieved successfully.

    • False: If the row count is not retrieved successfully.

• Logical Explanation: The Get Total Row Count action does not require any input value. It reads the captured grid element and calculates the total numbers of rows present in it. The retrieves total rows count (100) is stored in the {Count} variable.

Example 2: Retrieving the Row Count from a Specific Section of a Grid

In this example, we are explaining how to retrieve the total number of rows from a specific section of a captured table or grid.

• Action: Get Total Row Count

• Input Value: body;left

  • The first argument (body) specifies the section of the grid from which the rows should be counted.

  • The second argument (left) specifies the direction to be applied while retrieving the row count.

• Output Value: {Count}

  • The total number of rows in the specified section (45) is stored in the {Count} dynamic variable.

  • If a second output variable is provided, the action status is stored in the {Status} variable, with the following possible values:

    • True: If the row count is retrieved successfully.

    • False: If the row count is not retrieved successfully.

• Logical Explanation: The Get Total Row Count action reads the details from the Input Value column (body;left). It identifies the specified section of the grid and applies the direction provided. Based on these inputs, it counts the total number of rows present in that portion of the grid. The resulting count (45) is stored in the {Count} variable.

Example 3: Retrieving the Visible Row Count from the Current Grid Page

In this example, we are explaining how to retrieve the number of rows that are currently visible on the active page of the captured table or grid.

• Action: Get Total Row Count

• Input Value: visible

  • The argument (visible) specifies that the action should count only the rows displayed on the current page of the grid.

• Output Value: {Count}

  • The total number of rows in the specified section (85) is stored in the {Count} dynamic variable.

  • If a second output variable is provided, the action status is stored in the {Status} variable, with the following possible values:

    • True: If the row count is retrieved successfully.

    • False: If the row count is not retrieved successfully.

• Logical Explanation: The Get Total Row Count action reads the details from the Input Value column (visible). Based on this input, it focuses on the rows currently displayed on the active page of the grid, ignoring any rows on other pages or in hidden sections. It counts the total number of visible rows (85) is stores in the {Count} variable.