Get Row Number by Text

This is a pre-built Action located under the captured grid element. The functionality of this action in Avo Assure is to fetch the row number of the specified input text in the grid. The result is stored in the given dynamic variable for further use during test execution

Syntax

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

Argument	Description
<text> (Required)	Provide the text you want to search within the grid.
<header/body> (Optional)	Provide whether you want to perform the search in the header or body of the grid.
<left/right> (Optional)	Provide the direction you want to use for searching within the grid.
<row_attr> (Optional)	Provide any additional row attribute or identifier you want for accurate targeting.

Note: If the row attribute name is specified, the action returns the value for that attribute. If the row attribute name is not specified, the action retrieves the row index value.

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

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

Example 1: Retrieving the Row Number Based on a Specific Input Text in a Grid

In this example, we are explaining how to find the row number of a grid cell that contains a specified text value.

• Action: Get Row Number by Text

• Input Value: James D Davis

  • The argument (James D Davis) specifies the text to search for.

• Output Value: {Number}

  • The row number where the text is found (6) is stored in the {Number} 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 number is retrieved successfully.

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

• Logical Explanation: The Get Row Number by Text action reads the details from the Input Value column (James D Davis). It searches for that text within the table rows. After the matching cell is found in the specified section. The action retrieves the corresponding row number (6) and stores it in the {Number} variable.

Example 2: Retrieving the Row Number Based on a Specific Input Text and Additional Parameters in a Grid

In this example, we are explaining how to find the row number of a grid cell that contains a specified text value.

• Action: Get Row Number by Text

• Input Value: James D Davis;body;left

  • The first argument (James D Davis) specifies the text to search for.

  • The second argument (body) specifies the section of the table to search within.

  • The third argument (left) specifies the direction or alignment to consider while searching.

• Output Value: {Number}

  • The row number where the text is found (6) is stored in the {Number} 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 number is retrieved successfully.

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

• Logical Explanation: The Get Row Number by Text action reads the details from the Input Value column (James D Davis;body;left). It searches the specified section (body) of the table in the given direction (left) to locate the cell containing the text (James D Davis). After the matching cell is found. The action retrieves the corresponding row number (6) and stores it in the {Number} variable.