Document toolboxDocument toolbox

Header

(8.6.X) SFDCDataTable

Owned by Dhiraj Chandanshive (Unlicensed)
Last updated: Oct 27, 2022
13 min read

DataTable

The DataTable SFDC component supports the following actions:

  • Click

  • ClickCellWithCellText

  • ScrollAndStoreRowCount

  • SortColumnData

  • StoreCellText

  • StoreExistence

  • StoreRowNumberOfCellText

  • StoreRowNumberOfMultipleCellText

  • VerifyCellText

  • VerifyRowData

  • WaitForCellChildElement

  • WaitForCellClickability

  • WaitForCellNonClickability

  • WaitForCellExistence

  • WaitForCellInnerTextContains

  • WaitForCellInnerTextNotContains

  • WaitForCellInnerTextMatchesPattern

  • WaitForCellInnerTextToBe

  • WaitForCellInnerTextNotToBe

  • WaitForCellVisibilty

  • WaitForCellInvisibilty

  • WaitForCellNonExistence

  • WaitForCellSelection

  • WaitForCellSelectStateToBe

  • WaitForCellStaleness

  • StoreRowNumberOfCellText

  • VerifyPropertyValue

  • StorePropertyValue

  • MouseOver

  • VerifyExistence

  • VerifyEnability

  • VerifyVisibility

Click

This action clicks the specified object.

This action does not have any parameters.

Example:

Click

ClickCellWithCellText

This action clicks on cell according to the provided cell data, rowNumber and columnNumber.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

cellText

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

Example:

ClickCellWithCellText “Test1” “5” “1”

ScrollAndStoreRowCount

This action scrolls till the last row and stores the total row count of the table.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter the key in which the row count will be stored.

Yes

String

Example:

ScrollAndStoreRowCount “key_1”

SortColumnData

This action sorts the data when the user clicks on heading cell of any particular column.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

columnName

Enter the name of the column.

Yes

String

sortOrder

Enter the direction in which the data needs to be sorted. 1 indicates ascending order and 2 indicates descending order.

No

String

Example:

SortColumnData “Account Name” “1”

StoreCellText

This action stores the cell data in key of the provided row number and column number.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

key

Enter the key in which the row count will be stored.

Yes

String

Example:

StoreCellText “1” “3” “key_2”

StoreExistence

This action stores existence of the object under the specified key. The key value can be retrieved using the key name. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the key name under which the existence's Boolean value will be stored. 

  • Stores True if the object exists.

  • Stores False if the object does not exist.

Yes

String

Example:

StoreExistence               "Key"

StoreRowNumberOfCellText

This action stores row number of the provided cell text.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

text

Enter the text of the cell.

Yes

String

columnNumber

Enter the index of the column.

No

Number

key

This will return the row number.

Yes

String

Example:

StoreRowNumberOfCellText             "Test1" “1” “key_3”

StoreRowNumberOfMultipleCellText

This action stores the row number with provided cell texts and column numbers, and the value is stored in the key.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

text

Enter the text of multiple cells separated by delimiter.

Yes

Array

columnNumber

Enter the index of the column respective to cell data (separated by delimiter).

Yes

Number

key

This will return the row number.

Yes

String

Example:

StoreRowNumberOfMultipleCellText         "Test1^India^998660^Active" “1^2^3^4” “key_4”

VerifyCellText

This action verifies if the provided cell text value along with row number and column number is present in DataTable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

data

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

Example:

VerifyCellText         “Test1” "5" “1”

VerifyRowData

This action verifies if the provided cell text values along with row number is present in DataTable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

rowNumber

Enter a number which points to the row as per listOfValues.

Yes

Number

listOfValues

Enter the values with a separator/delimiter as caret.

Yes

Array

Example:

VerifyRowData         “2” "Test1^India^998660^Active"

WaitForCellChildElement

This action waits for the cell to contain child element until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

childLocatorType

Enter the locator type of cell’s child element.

Yes

String

childLocatorValue

Enter the locator value of cell’s child element.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

key

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellChildElement “Xpath” “//*[@id=”brandBand_1]” “5” “2” “1”

WaitForCellClickability

This action waits until the cell of datatable becomes clickable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyClickability

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellClickability         “10” “2” “2” “5” "keyClickability" “Fail”

WaitForCellNonClickability

This action waits until the cell of datatable becomes non-clickable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyNonClickability

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellNonClickability         “10” “2” “5” “5” "keyNonClickability" “Fail”

WaitForCellExistence

This action waits for the cell to exist, i.e. it is in DOM, in datatable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

key

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellExistence         “10” “5” “5” “5” “keyNonClickability” “Fail”

WaitForCellNonExistence

This action waits for the cell to not exist, i.e. it is not in DOM, in datatable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

key

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellNonExistence         “10” “5” “2” “5” “key” “Fail”

WaitForCellInnerTextContains

This action waits for inner text of the cell to contain the expected text until timeout expires. If cell/datatable is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

innerText

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInnerText

Enter the key in which the innerText needs to be stored.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInnerTextContains         “Test1” “2” “5” “10” “5” “key” “Fail”

WaitForCellInnerTextNotContains

This action waits for inner text of the cell to not contain the expected text until timeout expires. If cell is found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

innerText

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInnerText

Enter the key in which the innerText needs to be stored.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInnerTextNotContains         “Test” “2” “5” “10” “5” “keyInnerText” “Fail”

WaitForCellInnerTextMatchesPattern

This action waits for inner text of the cell to match the specified pattern until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

innerTextRegXPattern

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInnerText

Enter the key in which the innerText needs to be stored.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInnerTextMatchesPattern         “^t.*es$t” “2” “5” “10” “5” “keyInnerText” “Fail”

WaitForCellInnerTextToBe

This action waits for inner text of the cell to be the expected inner text until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

innerText

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInnerText

Enter the key in which the innerText needs to be stored.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInnerTextToBe         “TestUpdate1” “2” “5” “10” “5” “keyInnerText” “Fail”

WaitForCellInnerTextNotToBe

This action waits for inner text of the cell to not be the expected inner text until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

innerText

Enter the text of the cell.

Yes

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInnerTextNotToBe

Enter the key in which the innerText needs to be stored.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInnerTextNotToBe         “TestUpdate1” “2” “5” “10” “5” “keyInnerText” “Fail”

WaitForCellVisibilty

This action waits for the cell to be visible in datatable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyvisibility

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellVisibilty         “10” “2” “3” “5” “keyVisibility” “Fail”

WaitForCellInvisibilty

This action waits for the cell to be invisible in datatable.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keyInvisibility

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellInvisibilty         “10” “2” “5” “5” “keyInvisibility” “Fail”

WaitForCellSelection

This action waits for selection of the cell until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

key

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellSelection         “10” “5” “2” “5” “key” “Fail”

WaitForCellSelectStateToBe

This action waits for selection state of the cell to be expected state until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

expectedSelectionState

Enter true for selected and false for deselected. The default value is true.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

keySelectionState

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellSelectStateToBe         “True” “10” “5” “3” “5” “key” “Fail”

WaitForCellStaleness

This action waits for staleness of the cell until timeout expires. If object is not found in the DOM, step status will fail. If key is provided, status will be stored in key. The status depends on the statusIfConditionNotSatisfied parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

timeOut

Enter the timeout (in seconds) to wait for the object visibility.

No

String

rowNumber

Enter the index of the row.

Yes

String

columnNumber

Enter the index of the column.

Yes

String

pollingInterval

Enter the frequency (in milliseconds) after which you want to check for the object visibility before exhausting timeout.

No

String

key

Enter the key name under which the status of the step needs to be stored. It stores 0 for Pass, 1 for Fail, and 2 for Defect.

No

String

statusIfConditionNotSatisfied

Enter the status of the step you want to display in the report if the expected condition is not satisfied. The value for this parameter can be Pass, Fail, and Defect.

No

String

Example:

WaitForCellStaleness       “10” “5” “2” “5” “key” “Fail”

VerifyPropertyValue

This action verifies the property of the specified object using property names, such as class, id, name, and role, and parameter value, such as the actual value of the property.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

propertyName

Enter the property or attribute name as specified in the DOM structure.

Yes

String

value

Enter the property value you want to verify.

Yes

String

Example:

VerifyPropertyValue      "class"    "fr small"

StorePropertyValue

This action stores the property of the specified object using  property names, such as class, id, name, and role, and parameter value, such as the actual value of the property.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter a variable to store the property value.

Yes

 String

propertyName

Enter the property or attribute name whose value you want to store.

Yes

 String

Example:

StorePropertyValue      "key"    "class"

MouseOver

This action hovers over the specified object.

This action does not have any parameters. 

Example:

MouseOver

VerifyExistence

This action verifies the existence of the specified object. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

existence

Enter one of the following:

  • True to verify that the object is enabled.

  • False to verify that the object is disabled.
    Note: If you do not enter any value, the default value is set to True during the test case execution

No

String

Example:

VerifyExistence      "True"

VerifyEnability

This action verifies the enability of the specified object. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

enability

Enter one of the following:

  • True to verify that the object is enabled.

  • False to verify that the object is disabled.
    Note: If you do not enter any value, the default value is set to True during the test case execution.

No

String

Example:

VerifyEnability      "True"

VerifyVisibility

This action verifies the visibility of the specified object. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Parameter Name

Parameter Description

Mandatory

Data Type

existence

Enter one of the following:

  • True to verify that the object is visible

  • False to verify that the object is not visible.
    Note: If you do not enter any value, the default value is set to True during the test case execution.

No

String

 

Example:

VerifyVisibility     "True"

Footer