Verify Column Value

This is a pre-built action in Avo Assure. This action validates whether a specific value is present in All rows of a designated column in a table. If the value is present in the table, then the output will be true; otherwise, the output will be false.

Syntax

Input: <Column Header>;Value; Allrow (Optional)

	Description
Column Header (*Mandatory)	The column in which we want to search for value
Value (*Mandatory)	The value which we want to search
Allrow (*Optional)	This is optional parameter. It will search for value in every row of the column.
Anyrow (*default)	This is the default parameter. If we don't provide 3rd parameter as All row, it will by default take the 3rd parameter as ANYROW and will search for value in any row of the column.

Note:

• ALLROW/ANYROW, are not case sensitive

• In above example: Fee Events is element in our script, Verify Column Value is action name and Input value is Account Name;ABBOTT MILK;allrow. We will search for all rows in which abbott milk text is present.

ALLROW Pass/Fail:

•If pass a value which is present in all rows in a column - It will pass

• If pass a value which is present in 1 row in a column and grid is showing only 1 row - It will pass

• If pass a value which is not present in all rows in a column - It will fail.

• If pass a value which is present in only 1 row, but rest rows have different data in a column - It will fail.

•If pass a value and grid has zero rows - It will Fail.

ANYROW Pass/Fail:

•If pass a value which is present in only 1 row, but rest rows have different data in a column - It will pass.

•If pass a value which is present in a column and grid is showing only 1 row - It will pass.

• If pass a value which is present in more than 1 row in a column - It will pass.

• If pass a value which is not present in any rows in a column - It will fail.

•If pass a value and grid has zero rows - It will fail.

Output: <Dynamic Variable>(Optional)

Example 1 - Any Row

Search for the Age value 30 in the grid and display the result. The Verify column value action takes the value (30), searches for it in the table in any row, and returns True if the value exists or False if it does not. Use a dynamic variable to display the result.

Input value: Age;30