Get Column Number of Input 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 column number of the specified input text from 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);<col_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.
<col_attr> (Optional)	Provide any additional column attribute or identifier you want for accurate targeting.

Note: If a column attribute name is specified, the action returns the value for that attribute name. If no column attribute name is specified, the action retrieves the column index value.

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

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the retrieved column number.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example 1: Identifying the Column Number Containing a Specific Input Text

In this example, we are explaining how to identify the column number in a captured grid that contains a specific text value.

• Action: Get Column Number of Input Text

• Input Value: Loan Type;header

  • The first argument (Loan Type) specifies the text to search for in the table.

  • The second argument (header) specifies the section of the grid in which the search should be performed.

• Output Value: {Column}

  • The column number where the text is found (4) is stored in the {Column} dynamic variable.

  • If a second output variable is defined, it stores the action status with the following possible values:

    • True: If the column is found successfully.

    • False: If the column is not found successfully.

• Logical Explanation: The Get Column Number of Input Text action reads the details from the Input Value column (Loan Type;header). It scans the specified header row of the grid and searches for the text Loan Type. After identifying the matching column, the action returns its column number (4) and stores it in the {Column} variable.

Example 2: Identifying the Column Number Containing a Specific Input Text

In this example, we explain how to identify the column number in a captured table that contains a captured table based on the input text and additional table identifying attributes.

• Action: Get Column Number of Input Text

• Input Value: Loan Type;header;left

  • The first argument (Loan Type) specifies the text to search for in the table.

  • The second argument (header) specifies the section of the table in which the search should be performed.

  • The fourth argument (left) defines the search direction for locating the cell.

• Output Value: {Column}

  • The column number where the text is found (4) is stored in the {Column} dynamic variable.

  • If a second output variable is defined, it stores the action status with the following possible values:

    • True: If the column is found successfully.

    • False: If the column is not found successfully.

• Logical Explanation: The Get Column Number of Input Text action reads the details from the Input Value column (Loan Type;header;left). It scans the specified header row of the grid and searches for the text Loan Type. After identifying the matching column, the action returns its column number (4) and stores it in the {Column} variable.