Clipboard.Copy

This action copies the data given into the parameter to clipboard.

Input Parameters:

 Example:

Clipboard.Copy            "Qualitia Software Pvt. Ltd."

Clipboard.Clear

This action clears the data present on the clipboard memory.

This action does not have any input parameters.

Example:

Clipboard.Clear

CloseCurrentWindow

This action will close current window.  

This action does not have any parameter.

Example:
 CloseCurrentWindow

CheckExcelProcess

This action will check if the excel process is running.

This action does not have any parameter.

Description: It will pass if the excel process is running on your system. Otherwise, it will fail.

Example:

CheckExcelProcess

ConcatString

This action will concatenate the two strings and stores result string into a variable. The key value can be retrieved using the key name.

Input Parameters:

Example:

ConcatString  “Hello “ “World” “Result”

ComparetwoStrings (Deprecated)

This action will compare two string values. As it is deprecated, Qualitia recommends to use CompareString.

 Input Parameters:

Example:

ComparetwoString  “hello“  “ hello”

ComparetwoInt

This action compares two integer numbers. Even a key can be passed as one of the parameters for comparison where the ComparetwoInt function will retrieve the value from the key and that value will be compared with another integer.

 Input Parameters:

Example:

ComparetwoInt  “123“  “ 234”

DragAndDropToObject

This action drags the specified object and drops it in the position of another specified object. 

Input Parameters:

Example:
DragAndDropToObject                   "//div/img[@alt='abx']"            "xpath"           "abc"        "id"

OpenURL

This action opens the specified URL in the browser selected in the associated execution profile.

Input Parameters:

Example:

OpenUrl                               "http://www.google.com/ "

When using this action in Desktop projects, Qualitia defines its own set of system variables which can be used later when executing test cases. These variables are stored in Qualitia with their expressions (True or FALSE). Following is the list of system variables that Qualitia stores when executing the OpenURL action.

• $$_ISIE: If browser type is set as IE (Internet Explorer), then this expression is stored as True. Here, other two ($$_ISFIREFOX and $$_ISCHROME) are stored as FALSE.

• $$_ISFIREFOX: If browser type is set as FIREFOX (Mozilla Firefox), then this expression is stored as True. Here, other two ($$_ISIE and $$_ISCHROME) are stored as FALSE.

• $$_ISCHROME: If browser type is set as CHROME (Google Chrome), then this expression is stored as True. Here, other two ($$_ISFIREFOX and $$_IE) are stored as FALSE.

Note: It is recommended to close all the unnecessary browsers before starting the test execution or object spying using UFT.

NavigateForward

This action navigates the browser to the next page.

This action does not have any parameter.

Example:

NavigateForward

NavigateBack

This action navigates the browser to the previous page.

This action does not have any parameter.

Example:

NavigateBack

RandomString

This action takes input as list of characters from user and gives random string as output of a specified length.

For example, if the string is "RTFTF" and length is "10", then it randomly generates a string as "RTFTTFRTFR".  

Input Parameters:

Example:

RandomString  "32#$abd "            "12"      “abc”

ReplaceStringBySubString

This action replaces the specified part from the string with another string and stores the updated value into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

ReplaceStringBySubString          "Key"           "Australia"       "A"         "B"        "1"         "-1"        "1"

In this case,  the string Australia changes to Bustralia.

ReplaceAndStoreText

This action replaces a substring by another substring into a source string and stores the resulting string in the given key.

Input Parameters:

Example:

ReplaceAndStoreText              "India"          "i"               "Z"          "True"         "key1"

The result string will be IndZa.

ReplaceSubString

This action replaces a substring of an original string with a specified string.

For example, if a string is "WELCOMEWELCOME" and if you want to replace the second occurence of the substring "come" with gone". Then, the new string generated is 'WELCOMEWELGONE".

Input Parameters:

Example

ReplaceSubString “welcome” “come”  “gone”  “1”  "True" “abc”

RandomNumber

This action takes lower and upper limit of a range as integer input and gives an output of a random integer number within that range.

Input Parameters:

Example

RandomNumber  "1"   "100"      

StorePageURL

This action stores the URL of the web page under the specified key. The stored value can be retrieved using the key name. 

Input Parameters:

Example:

StorePageURL                   "Key"

RightClickTo(String X , String Y)

This action right-clicks at a definite location of the web page as specified by x and y coordinates. You cannot specify negative values to X and Y.

Example: 
String X = "100" , String Y = "100" . The right-click will occur at the location point (100,100).

ScrollTo(String X, String Y)

This action scrolls the Scrollbar of the web page to a definite location specified by x and y coordinates. You cannot specify negative values to X and Y.

Example:

String X = "100" , String Y = "100" . The scrollbar scrolls to the location point (100 ,100).

StoreFixNumber

This action stores the integer part of a specified number into the specified key. The stored key value can be retrieved using the key name.

Input Parameters:

Example:

StoreFixNumber           "Key"              "6.4332"

In this case, the variable Key stores the value to 6.

StorePageTitle

This action stores the web page title under the specified key. The stored value can be retrieved using the key name. 

Input Parameters:

Example:

StorePageTitle                   "Key"

StoreVariable

This action stores a particular string value under the specified key. This value can be used when developing test cases.  

Input Parameters:

Example:

StoreVariable                   "url"                     "http://www.bing.com/ "  

SecureStoreVariable

This action stores the specified value securely by encrypting it under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

SecureStoreVariable              "Password"                               "Encrypt(Abc)"

When the focus is moved away from the data ABC, Qualitia will automatically encrypt the text to "vHpmlfI4R3PQJskt3nuqw==þNWE3ZDdkNjE3N2JmNDM2ODgxMzQwYWI1MTA3YWNjMDc="

CalculateDifferenceInDateAndStore

This action calculates the difference between two specified dates as per the number of days. The key value can be retrieved using the key name.

Input Parameters:

 Interval: The interval parameter can have the following values:

Example:
CalculateDifferenceInDateAndStore      "Key"            "D"        "01-Jan-2021"      "28-Feb-2021"

Sleep

This action adds the delay during execution for the given period of time (in seconds).

This action can be used when a particular action takes some time for execution. For instance, after performing an OpenUrl action, some amount of wait can be given till the URL is opened completely.

Input Parameters:

Example:
Sleep                   "20"

SelectPage

This action helps Qualitia users to move focus from one window/page to another as per the test case requirements. 

Input Parameters:

Example:

Select Page                            "Name"

SelectWindowUsingURL

This action selects the window using the URL address or URL pattern specified in the parameters.

Input Parameters:

Example:

SelectWindowUsingURL                      "www.google.com"                    "False"

ClosePopUpBrowser

This action closes the popup that appears on the web page. 

Input Parameters:

Example:
ClosePopUpBrowser                   "viewPage"

PressKeys

This action sends one or more keystrokes to the active window (as if typed on the keyboard).

Input Parameters:

Example:

To open the Find dialog on the browser, which is done manually using Ctrl + F.  While using the PressKeys action, the data to be passed is ~^F where ^ means Control. See the list below for the keys and their meaning).

The action returns 0, if the key is pressed successfully else it will return 1 in any other case. 

Note: If a PressKeys action does not execute on an Inactive Screen, refer to PressKeys Action does not Execute on an Inactive Screen.

Important Note:

The data to be passed here is only ^F. However ^ has a special meaning in QAS, it must be preceded with an escape sequence ~. Hence the data passed is written as ~^F.
Make sure to prefix an escape sequence which is a tilda for the following characters which has a special meaning in Qualitia. The characters are {,}, ^, ~
Example:

1. If key to be sent is {F1}, enter data as ~{F1~}.

2. To send {TAB}, enter data as ~{TAB~}.

3. To send {ENTER}, enter data as ~{ENTER~}.

Use the PressKeys action to send keystrokes to applications that have no automation interface. Most keyboard characters are represented by a single keystroke. Some keyboard characters are made up of combinations of keystrokes (CTRL+SHIFT+HOME, for example). To send a single keyboard character, send the character itself as the string argument. For example, to send the letter x, send the string argument "x".

You can use PressKeys to send more than one keystroke at a time. To do this, create a compound string argument that represents a sequence of keystrokes by appending each keystroke in the sequence to the one before it. For example, to send the keystrokes a, b, and c, you need to send as "abc". The PressKeys method uses some characters as modifiers of characters (instead of using their face-values). This set of special characters consists of parentheses, brackets, braces, and the:

• plus sign       "~{+~}",

• caret             "^", (use with an escape character [~])

• percent sign "%"

• tilde       "~"

Enter these characters by enclosing them within braces "{}". For example, to enter the plus sign, enter the string argument "{+}". Brackets "[ ]" have no special meaning when used with PressKeys, but you must enclose them within braces to accommodate applications that do give them a special meaning (for dynamic data exchange (DDE) for example).

• To send bracket characters, enter the string argument "{[}" for the left bracket and "{]}" for the right one.

• To send brace characters, enter the string argument "}" for the left brace and "{" for the right one.

• To send a key combination that includes Ctrl key such as Ctrl + N send "~^n"

Some keystrokes do not generate characters (such as ENTER and TAB). Some keystrokes represent actions (such as BACKSPACE and BREAK). To send these kinds of keystrokes, enter the associated arguments as shown in the following table:

To send keyboard characters that are comprised of a regular keystroke in combination with a SHIFT, CTRL, or ALT, create a compound string argument that represents the keystroke combination. You can do it by preceding the regular keystroke with one or more of the following special characters:

 When used this way, these special characters are not enclosed within a set of braces.

To specify that a combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, create a compound string argument with the modified keystrokes enclosed in parentheses. For example, to send the keystroke combination that specifies that the SHIFT key is held down while:

• e and c are pressed, enter the string argument "+(ec)".

• e is pressed, followed by a lone c (with no SHIFT), enter the string argument "+ec".

You can use the PressKeys action to send a pattern of keystrokes that consists of a single keystroke pressed several times in a row. To do this, create a compound string argument that specifies the keystroke you want to repeat, followed by the number of times you want it repeated. To do this, use a compound string argument of the form {keystroke number}. For example, to send the letter "x" ten times, you would send the string argument "~{x 10~}" where you need to ensure that you enter a space between keystroke and number.

StoreDateTimeByZone

This action helps to convert the date and time provided by the user into the expected time zone.

Input Parameters:

Example:

StoreDateTimeByZone          “EST”         “IST”      “2018-09-23 12:34:44”          “yyyy-mm-dd hh:mm:ss”       “ESTTime”

• Result:

End of the execution, this action converts the given time into the expected time zone and stores it in under the key: ESTTime.

List of Zone IDs:

Here is the complete list of supported Zone IDs and their descriptions. Please note that these Zone IDs mentioned herein is case-sensitive and should be used in the upper case only.

List of supported dateTimeFormats:

Here is the complete list of date and time formats and their examples. Please note that these date and time formats mentioned herein are case-sensitive and should be used in the same way as mentioned in the table below. 

StoreSubStringNew

This action stores a sub string of a string into a variable. The key value can be retrieved using the key name. 

Input Parameters:

Example:
StoreSubStringNew                   "resultSubString"            "This is a test"                "2"                  "4"

StoreSubStringFromIndexForLength

The action stores the substring of a string from a specific index up to any number of characters that you want. The indexing starts from 1.

Input Parameters:

Example:

StoreSubStringFromIndexForLength     "Key"    “Welcome"     “4”      “4”

The variable Key stores the value as come.

StoreStringToInteger

This action converts the provided string to the integer value and stores it into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

StoreStringToInteger            "Key"          "20"

StoreStringLength

This action increments the string length by the value specified by the user and stores it into a variable.

Input Parameters:

Example:
StoreStringLength                             "length"                      "This is a test"            "3"

CompareString

This action compares two strings without trimming the spaces. The comparison can be either case-sensitive / non case-sensitive. Even a key can be passed as one of the parameters for comparison where the CompareString function will retrieve the value from the key and that value will be compared with expected.

Input Parameters:

CompareString           "{key}"           "Cancel"          "True"

Here the CompareString action shall retrieve the value for the key (here Cancel) and compare it with the expected (here Cancel) with case sensitive comparison as True. The action will return 0, if the strings match else it will return 2 if the strings do not match. It will return 1 in any other case (like an error).

PrintMessageinReport

This action helps you to print the desired message in Qualitia test case execution report. 

Input Parameters:

Example:

PrintMessageInReport         "Test case executed successfully without fail."                "Passed"

VerifyStringContainsValue

This action verifies whether a specific substring is present in the main string. Comparison can either be case-sensitive or case-insensitive.

Input Parameters:

VerifyStringContainsValue      "{mainStrKey}"                               "the action"              "True"

In this case, the VerifyStringContainsValue action shall retrieve the value for the key mainStrKey and compare it with the expected with case sensitive comparison as True.
The action returns  the following values:

• PASSED if the substring is found in the main string.

• DEFECT if the substring is not found in the main string.

• FAILED if the main string or substring is empty.

Empty and null main string as well as substrings are not  verified by this action.

ComparePattern

This action compares the data passed by user and verifies that it matches the pattern specified by the user.  

Input Parameters:

Example:
Consider a bank application where on adding a user an account number is generated which is unique and consists of alphanumeric characters. The number of characters in that account number is 10 where the first 5 are alphabets and remaining five are numbers.

Suppose the account number is YuIFp96062. If this has to be verified for the pattern mentioned, we can use the action ComparePattern as follows:

• strPattern -  [a-z]~{0,5~}[0-9]~{5~}

• strData –  YuIFp96062

• blnCase -    False

ComparePattern                 “[a-z]~{0,5~}[0-9]~{5~}“                   "YuIFp96062"                  "false"

Here the ComparePattern action shall verify that data mentioned matched the specified pattern .The action will return 0, if the data matches the specified pattern , else it will return 2 if the data does not match the pattern. In any other case it will return 1.

If the pattern is using Qualitia's special characters like {,},/,^ then they should be prefixed with ~.

Special characters and sequences are used in writing patterns for regular expressions. For a complete list of the regular expression syntax visit the VBScript syntax Guide for Regular Expressions.

CompareSubStringPattern

This action verifies whether a string or any of its substring is defined in the desired pattern that you want.

The action returns the following values:

• PASSED if the string or any of its substring matches with the desired pattern.

• DEFECT if the string or any of its substring does not match with the desired pattern..

• FAILED for any other reason, such as when no value is defined for strData or strPattern parameters.

Example:
CompareSubStringPattern [a-z]~{0,5~}[0-9]~{5~} YuIFp96062 True
In this case, the substring 'p96062' matches with the given case-sensitive pattern. Hence, the action will return Pass.

CompareSubStringPattern ~^[a-z]~{0,5~}[0-9]~{5~}$ YuIFp96062 True
In this case, the action matches the complete string with the specified pattern where it does not match. Hence, the action will return Defect.

VerifyDataType

This action verifies if the data type is numeric or string.

Input Parameters:

Example:

VerifyDataType "4.78" "numeric"
This shall verify if 4.78 is numeric
VerifyDataType "This is a test" "string"
This shall verify if "This is a test" is a string
Anything which is not numeric shall be considered as a string.
Example: "Enter 123", "23/02/20" etc shall be considered as a string.

VerifyDifference

This action verifies the difference between two integer values and validates it with the expected difference value.

Input Parameters:

Example:
VerifyDifference                       "30"                 "40"               "10"

StoreSplitString

This action splits the string based on the specified delimiter character and stores the value that is contained between its previous occurrence of the delimiter into a variable. If there are n delimiters, then there are  (n+1) substrings.

Input Parameters:

Example:

StoreSplitString                "spaceKey"         "https://my.atlassian.net/wiki/rest/api/content?spaceKey=QASM=limit=500&start=0"              "="                     "2"

In this example, the delimter is =, as there are multiple occurrences of =in the mainString,,  after this action is executed, the text between 2nd and 1st delimiter character that is QASM will be stored under the specified key spaceKey.

MaximizeBrowser

This action maximizes the browser.

This action does not have any parameter. 

Example:

MaximizeBrowser

SelectFrame

This action selects a frame within the current window.

Input Parameters:

Example:

SelectFrame                        "mainFrame"               "name"

SelectFrameUsingUrl

This action is used to select a frame irrespective of the frame hierarchy. The frame can be either be an iframe or a normal frame, which are defined in html by <iframe> and <frame> tag respectively.

To pass the URL, do one of the following:

• Set the StringisUrlPattern parameter to false to pass the exact URL of the frame that you want to select.

• Set the StringisUrlPattern parameter to True to pass regex pattern for a particular URL.

In both cases, if the given URL has multiple frames, the first frame in the frame hierarchy is selected. If the frame URL does not exist, the context switches to either the first frame on the page, or the main document if the page contains iframes.

Example

• String "https://ogs.google.com/widget/app/soorigin=https%3A%2F%2Fwww.google.com&pid=1&spid=1&hl=en&gm=", String "false" .
  The selectFrameUsingUrl action will select the first frame from the frame hierarchy pointed by the given URL.

• String "^.*?(\\w+)?\\..*?$" , String "True"

The SelectFrameUsingUrl action will select first frame from the frame hierarchy which is found as per the regex pattern.

StoreCurrentDateInFormat

This action stores the current date in the specified format under the key name. The key value can be retrieved using the key name. 

Input Parameters:

Example:
StoreCurrentDateInFormat                             "MM-dd-yyyy"                "currentDateKey"

StoreDateInFormat

This action stores the date provided by the user in a specific format under the key. The key value can be retrieved using the key name.

Input Parameters:

Example:
StoreDateInFormat                      "30/Jan/2009"                    "dd/MMM/yyyy"               "dd-MMM-yyyy"             "Datekey"

TrimAndStoreText

This action trims the preceding and succeeding spaces and stores the resulting string in the given key.

Input Parameters:

Example:
TrimAndStoreText                "     John Doe       "           "FullName"

Suppose, you give the strText as "    John Doe    " to store the final string inside the key "FullName". End of the execution, John Doe  will be stored in the key FullName.

TrimAndCompareString

This action compares two strings. The comparison can be either case-sensitive / non case-sensitive. Even a key can be passed as one of the parameters for comparison where the TrimAndCompareString function will retrieve the value from the key and that value will be compared with expected. The spaces of both the strings are trimmed before comparing.

Input Parameters:

Example:

TrimAndCompareString      “Hello “     “ hello ”    “True”

VerifyDates

This action performs comparisons between two dates for various operations (equality, inequality, greater than, less than).

Input Parameters:

Example:

The result of this action shall be True or false depending on the operation performed.

VerifyDates                            "12-Jun-2008"                     "dd-MMM-yyyy"                          "04/12/2008"                      "dd/MM/yyyy"               "<"

No macro found named "DateTimeFormatSupported" on page "(8.5.X) General Web Actions" in space "QASNew".

If you're experiencing issues please see our Troubleshooting Guide

ChangeCaseAndStore

This action changes the case of the provided string and stores the final value into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

ChangeCaseAndStore                "Key"               "Qualitia"             "Upper"

ChangeDateAndStore

This action modifies the day/month/year by the number specified by the user and stores the resulting date under the specified key in the same format as the input date. The key value can be retrieved using the key name.

Input Parameters:

Example:
To change date from 1^st jan 2007 to 15 feb 2007 user can use 2 ways

1. Increment only the day value
   dayValue = 45, monthValue = 0 , yearValue = 0
   E.g.- ChangeDateAndStore                      "01-01-2007"                 "dd-MM-yyyy"              "45"             "0"               "0"         "key"

2. Increment the complete date
   dayValue = 14, monthValue = 1 , yearValue = 0
   E.g.- ChangeDateAndStore                      "01-01-2007"                 "dd/MM/yyyy"              "14"             "1"               "0"         "key"

Hence the user can either give the exact end date or can give the no of days, months or years by which the date needs to be changed.

CalculateDifferenceInDatesAndStore

This action calculates the difference in days between the two specified dates and stores the difference under the specified key. The key value can be used using the key name.

Input Parameters:

Example:
CalculateDifferenceInDatesAndStore                             "24-Jan-2007"                    "dd-MMM-yyyy"                     "01/26/2007"                      "MM/dd/yyyy            "diffKey"

VerifyDialogExistence

This action verifies if any dialog of the type alert/prompt/confirmation exists on the browser.

Input Parameters:

Example:
VerifyDialogExistence                       "True"

AcceptDialog

This action clicks the OK button on the alert/prompt/confirmation pop up.

This action does not have any parameter.

Example:
AcceptDialog

DismissDialog

This action cancels the alert/prompt/confirmation pop up.

This action does not have any parameter.

Example:
DismissDialog

StoreDialogText

This action stores the message from the alert/prompt/confirmation pop up under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

StoreDialogText               "message"

ExecuteFile

This action executes the batch file specified by the user.

Input Parameters:

Example:
ExecuteFile                     "C:\test\batchfile1.bat"

AttachFile

This action sets a file path in the file object type in html. This action is applicable only for desktop web application.

Input Parameters:

Example:

AttachFile                    "fileBox"                "id"                 "c:/Folder/test.txt"

This action is designed to upload files from the local directory when executing the test case. In case your test execution environment is other than Local, such as Remote, Sauce, Perfecto, and so on, files will be uploaded from where you initiate the test case execution.
Also, execution of this action highly depends on the browser and driver version you are using.

For example: On Sauce Labs, this action found working seamlessly on Google Chrome version 60 and below and Mozilla Firefox version 47 and below with their default drivers. If the Google Chrome browser version is 61 to 64, you must use chromedriver version 2.29 for this action to work. This action does not work with Mozilla Firefox version 48 and above, Internet Explorer, and Safari browsers.

These findings are tested and verified at the time of documenting this information and are subject to change based on the changes made to the respective browser and driver versions.

ExecuteQueryAndStoreInFile

This action executes data manipulation queries like select and stores the result into a file.

The file types supported are xml, xls, and txt. The valid extensions are

1. For text file - .txt

2. For xml file- .xml

3. For excel file- .xls

The Qualitia supports querying on the following database types:

• MySql 5.1

• Oracle 10g

• MS Access

• SQL Server 2008

If this action fails upon execution, refer to  Actions Related to DB Failed upon Execution.

Connection to different databases 

1. Mysql:

 
a. Driver - "com.mysql.jdbc.Driver" 
b. Connection url - "jdbc:mysql://localhost:portNo/databasename?useUnicode=True&characterEncoding=utf8" 
i. Databasename -is the mysql database to which the user wishes to connect 

1. Oracle:

 
a. Driver - "oracle.jdbc.driver.OracleDriver" (case-sensitive)
b. Connection url - "jdbc:oracle:thin:@servername or ip:portNo:Databasename" 
i. Servername -is the name of the server .If the server is on local system, the server name is localhost. If the server is on remote system, the ip address of the remote server can be used. 
ii. portNo – is the port which shall listen the database connections. The default port for oracle is 1521. If the user has configured a specific port for listening, then that port number should be used here. 
iii. Databasename is the oracle database to which the user wishes to connect 

1. SQLServer:

 
a. Driver - "com.microsoft.sqlserver.jdbc.SQLServerDriver" 
b. Connection url - "jdbc:sqlserver://servername/ip:port;database=databasename;" 
i. Servername -is the name of the server .If the server is on local system, the server name is localhost. If the server is on remote system, the ip address of the remote server can be used. 
ii. portNo – is the port which shall listen the database connections. The default port for oracle is 1433. If the user has configured a specific port for listening, then that port number should be used here. 
iii. Databasename is the sql server database to which the user wishes to connect 

1. MSAccess using dsn:

 
a. Driver - "sun.jdbc.odbc.JdbcOdbcDriver" 
b. Connection url - "jdbc:odbc:dsn_name 
i. dsn_name -is the name of the dsn configured on the system . If multiple users are accessing the same dsn, then it needs to be configured on a shared path instead of local system path.

Input Parameters:

Example
ExecuteQueryAndStoreInFile "oracle.jdbc.driver.OracleDriver" "jdbc:oracle:thin:@localhost:1521:orcl" "scott" "tiger" "select * from test_table where id = 100" "C:\DBResults\XML\ORACLE\Result.xml"

ExecutQueryAndStoreInKey

This action executes data definitions queries like update, delete and stores the result into a key.

The Qualitia supports querying on the following database types:

• MySql 5.1

• Oracle 10g

• MS Access

• SQL Server 2008

If this action fails upon execution, refer to  Actions Related to DB Failed upon Execution.

Perform the following steps:

1. From the Qualitia client, select the associated project.

2. Click Settings > Project Configuration > Manage Dependent jar.

3. Enter the location of DB jar.

4. Click OK.

Connection to different databases 

1. Mysql:

 
a. Driver - "com.mysql.jdbc.Driver" 
b. Connection url - jdbc:mysql://localhost:portNo/databasename?useUnicode=True&characterEncoding=utf8" 
i. Databasename -is the mysql database to which the user wishes to connect 

1. Oracle:

 
a. Driver - "oracle.jdbc.driver.OracleDriver" 
b. Connection url - "jdbc:oracle:thin:@servername or ip:portNo:Databasename" 
i. Servername -is the name of the server .If the server is on local system, the server name is localhost. If the server is on remote system, the ip address of the remote server can be used. 
ii. portNo – is the port which shall listen the database connections. The default port for oracle is 1521. If the user has configured a specific port for listening, then that port number should be used here. 
iii. Databasename is the oracle database to which the user wishes to connect 

1. SQLServer:

 
a. Driver - "com.microsoft.sqlserver.jdbc.SQLServerDriver" 
b. Connection url - "jdbc:sqlserver://servername/ip:port;database=databasename;" 
i. Servername -is the name of the server .If the server is on local system, the server name is localhost. If the server is on remote system, the ip address of the remote server can be used. 
ii. portNo – is the port which shall listen the database connections. The default port for oracle is 1433. If the user has configured a specific port for listening, then that port number should be used here. 
iii. Databasename is the sql server database to which the user wishes to connect 

1. MSAccess using dsn:

 
a. Driver - "sun.jdbc.odbc.JdbcOdbcDriver" 
b. Connection url - "jdbc:odbc:dsn_name 
i. dsn_name -is the name of the dsn configured on the system . If multiple users are accessing the same dsn, then it needs to be configured on a shared path instead of local system path.

Input Parameters:

Example:
ExecuteQueryAndStoreInKey "oracle.jdbc.driver.OracleDriver" "jdbc:oracle:thin:@localhost:1521:orcl" "scott" "tiger" "delete from test_table where id = 100" "Resultkey"

CompareTabularResults

This action compares the database results in two files and displays only the difference in an Microsoft or a kingsoft Excel sheet. A link is generated in the log file. On clicking the link, the excel sheet opens in which the difference in the data is displayed. This action compares the following file types which contain DB results. These files contain the results after executing the queries using the actions "ExecuteQueryAndStoreInFile" or "StoreTableData". The supported file extension types are : txt, xml and xls.

1. text and text

2. text and excel

3. text and xml

4. xml and xml

5. xml and excel

6. excel and excel

Input Parameters:

Example
CompareTabularResults             "C:\DBResults\XML\ORACLE\Result.xml"                 "C:\DBResults\Excel\ORACLE\Result.xls"                     "MSExcel"

ComputeExpression

This action evaluates mathematical, relational, logical operations and stores the result under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

Mathematical Expression
ComputeExpression                "24*2+4"              "Result"

Example:

Relational Expression
ComputeExpression               "10*2<30"             "Result"

Example:

Logical Expression
ComputeExpression             "10*2+1>19&10*2+2<23'"     "Result"

CompareArray

This action compares two arrays for equality.

Input Parameters:

Example :
CompareArray "1^2^3^4" "1^2^3^4"             "exact"
CompareArray "1^2^3^4^5^6" "2^1^3^4"      "partial"

StoreWindowHandle

This action fetches the handle (identifier) of a window and stores under the specified key.  This key can the be used in action like SelectPage and ClosePopupBrowser to work on the specific page. This action can be used when the name of the window on which user needs to work on is not known.

Also, this action will have to be used immediately after every action which results in opening a new window. Only then user will be able to work on the new opened window. Thus, immediately after every action which opens a new window, this action will have to be used in order to fetch the identifier of the new window.

This action has to be used for every window of the application. For more information about this, please refer to the knowledge base here. 

Input Parameters:

Example: 
Object1                                   Click 
StoreWindowHandles            "new window" 
SelectPage                              "{new window}" 
EditObjectOnNewPage           Set                 Testing 
In the example above, on clicking on object1 a new window is opened on which actions need to be performed.

Use the action StoreWindowHandles to fetch the handle of the new window opened. Use the SelectPage action to select the window. Then user can work on an object present on the new page.

Also, when the action OpenUrl is used, user will have to store the handle on this main application window.

Example:

OpenUrl                                 "http://www.google.com"
StoreWindowHandle            "mainapplicationWindow"

ExitTask

This action skips the execution of the next step and continue executing the next task. 

This action is not available for test case level step.

This action does not have any parameter.

Example:

ExitTask

ExitTCIteration

This action skips the execution of the current iteration of test case and execute next iteration. In case of a single TC Iteration the test case execution will stop.

This action does not have any parameter.

Example:

ExitTCIteration

ExitSuite

This action stops the execution of the test suite and no further test cases will be executed.

This action does not have any parameter.

Example:

ExitSuite

VerifyLinkOnPage

This action verifies if there is any hyperlink exists on the page.

Input Parameters:

Example:
VerifyLinkOnPage                    "AdvancedSearch"

StoreChildCount

This action stores the child count for the specified locator. The action counts the last element in the Xpath which are placed inside the parent hierarchy. The child elements to be counted can be immediate children/descendants. The user should pass relevant Xpath to achieve children/descendants count.

Input Parameters:

Example
StoreChildCount                      "//table[@id='12']/tbody/tr/td/div"         "Key"

DownloadFile

This action clicks the link or element that opens a download window, which is used to download the files.  You need to handle the action externally as it does not wait until the file is downloaded.

 Qualitia uses its internal mechanism to handle the Download File pop-up screen.

Input Parameters:

Example:

Example:  DownloadFile               "C:/ProgramData"           "Qualitia"       "DOWNLOAD SAMPLE DOC FILE"       "Link" 

RefreshPage

This action simulates the refresh operation on the currently selected page.

This action does not have any parameter. 

Example:

RefreshPage

DeleteCookiesOnCurrentDomain

This action deletes all the cookies that are visible to the current domain. 

This action does not have any parameter. 

If the page is www.google.co.in and the user runs the above action, then all the cookies created by www.google.co.in will be deleted.

If there is a link in www.google.co.in and on clicking, it navigates to www.apple.com.

Again , when the user runs the above action, then all the cookies create by www.apple.com will be deleted.

Reiterating, to delete www.google.co.in cookies, the application needs to be in www.google.co.in domain.

This action will automatically, pick up the current domain and will delete cookies of that domain. The user just needs to make sure that he runs this action only in the domain for which the cookies are to be deleted.

Note: In HTML, due to security reasons, the only website that can read/delete a cookie is the one that creates it.

Example:
DeleteCookiesOnCurrentDomain

AcceptDialogAndStoreMessage

This action accepts the dialog appeared on the Web page and stores the message under the specified key. 

Input Parameters:

Example:
AcceptDialogAndStoreMessage                  "AlertMessage"

ValidateSyntaxInFile

This action validates the data given in the specified JSON or XML file.

Input Parameters:

Example: 

ValidateSyntaxInFile           "C:\Users\Qualitia\Cust_Details.json" 

End of the execution, if the data from the specified file is valid, action will pass, else action will fail. 

WriteToBuildProperty

This action writes a user defined property along with its value to qer.properties file. This customized information can be used in email notifications sent by Jenkins provided all the required email specific settings are done there in Jenkins.

Input Parameters:

Example:
WriteToBuildProperty             "propertyName"                 "propertyValue"

WindowsAuthenticationLogin

This action is required to add authentication details in the window to log into the application.

Input Parameters:

Example:

WindowsAuthenticationLogin                      "http://www.abc.com"               "testuser1"        "passwduser1"

NoOps

This is a placeholder action and cannot be executed. Qualitia selects this action for the steps present under the activity when auto-populating test case.

You are requested to replace this action with Qualitia executable action.

This action does not have any parameters. 

When executing test cases with this action, test cases will be failed to notify Qualitia users about replacing such actions.

MinimizeWindow

This action minimizes the window.

This action does not have any parameter. 

Example:

MinimizeWindow

SetPageLoadTimeout

This action sets the page load timeout when executing test cases. The time set here overrides the Page Timeout set in the associatedInput Parameters:

Example:

SetPageLoadTimeout             "20"

StorePageSource

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

Input Parameters:

Example:

StorePageSource             "PageSource"

StoreWindowHandleAtIndex

This action fetches the handle (identifier) of the specified window in the index and stores under the specified key.  This key can the be used in action like SelectPage and ClosePopupBrowser to work on the specific page. This action can be used when the name of the window on which user needs to work on is not known.

Input Parameters:

Example : 

StoreWindowHandleAtIndex              "Key"                   "4"

SwitchWebExecutionPlatform

This action changes the current Web execution platform from Desktop to Mobile. When used, web application test case will run on specified platform.

Input Parameters:

Example:

SwitchWebExecutionPlatform                        "Mobile"

WaitForNumberofWindowsToBe

This action waits until the number of open windows reaches the count specified in the parameter. You may use polling interval and timeout, if required.

Input Parameters:

Example:

WaitForNumberOfWindowsToBe       "3"         "10"      "500"       "Key"     "Defect"

SetWindowSize

This action sets the window size based on the parameters provided (height and width).

Input Parameters:

Example:

SetWindowSize          "1344"             "689"

StoreWindowSize

This action stores the current size of the window under the specified keys. These key values can be retrieved using the key names.

Input Parameters:

Example:

StoreWindowSize          "Height"             "Width"

SetWindowPosition

This action sets the position of the console window as per the specified position.

Input Parameters:

Example:

SetWindowPosition          "123"             "232"

StoreWindowPosition

This action stores the current position of the window under the specified keys. These key values can be retrieved using the key names.

Input Parameters:

Example:

StoreWindowPosition          "XCordinateValue"             "YCordinateValue"

SetFullScreen

This action sets the browser in the full screen mode. 

This action does not have any parameter.

Example:

SetFullScreen

ClickAndHold

This action clicks (without releasing) at the current mouse location.

This action does not have any parameter.

Example:

ClickAndHold

DoubleClick

This action performs a double click action at the current mouse location.

This action does not have any parameter. 

Example:

DoubleClick

RightClick

This action performs a right-click action at the current mouse location.

This action does not have any parameter.

Example:

RightClick

SelectFrameByIndexWhenAvailable

This action waits for the specified frame to appear on the page and selects when it is available. You may specify the timeout and polling interval, if required.

Input Parameters:

Example:

SelectFrameByIndexWhenAvailable       "3"         "10"      "500"       "Key"     "Defect" 

WaitForJavaScriptReturnsValue

This action runs the parameterized JavaScript code until it returns the value. You may specify the timeout and polling interval, if required.

Input Parameters:

Example:

WaitForJavaScriptReturnsValue       "return eval('2-1');"    "key"      "10"      "500"       "Key"     "Defect"  

WaitForJavaScriptThrowsNoExceptions

This action runs the parameterized JavaScript code until it throws the execption. You may specify the timeout and polling interval, if required.

Input Parameters:

Example:

WaitForJavaScriptThrowsNoExceptions       ""          "10"      "500"       "Key"     "Defect"  

WaitForTitleContains

This action waits for the web page title to contain expected partial parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.

Input Parameters: 

Example:

WaitForTitleContains      "Qualitia"          "5"          "500"        "Key"        "Defect"

WaitForTitleNotContains

This action waits until the web page title changes to other than the partial parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForTitleNotContains      "Qualitia"          "5"          "500"        "Key"        "Defect"

WaitForTitleToBe

This action waits for the web page title to contain exact expected parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.

Input Parameters: 

Example:

WaitForTitleToBe      "Qualitia"          "5"          "500"        "Key"        "Defect"

WaitForTitleNotToBe

This action waits until the web page title changes to other than the parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForTitleNotToBe      "Qualitia"          "5"          "500"        "Key"        "Defect"

WaitForURLContains

This action waits for the web page URL to contain expected partial parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForURLContains      "OAuth%9"          "5"          "500"        "Key"        "Defect"

WaitForURLNotContains

This action waits until the web page URL changes to other than the partial parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForURLNotContains      "OAuth%9"          "5"          "500"        "Key"        "Defect"

WaitForURLToBe

This action waits for the web page URL to contain exact expected parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForURLToBe      "https://google.co.in"          "5"          "500"        "Key"        "Defect"

WaitForURLNotToBe

This action waits until the specified web page URL value changes to other than the parameterized value. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForURLNotToBe      "https://google.co.in"          "5"          "500"        "Key"        "Defect"

WaitForURLPattern

This action waits until the specified web page URL value changes to the parameterized regular expression pattern. This comparison is case-sensitive. You may specify the timeout and polling interval, if required.  

Input Parameters:

Example:

WaitForURLPattern      "http[s]:\/\/www\.mysite\.com.*"          "5"          "500"        "Key"        "Defect"

WaitForAlertAndSendText

This action waits for the page to prompt an alert. After the alert is prompted, you can send the text specified in the parameter. You may specify the timeout and polling interval, if required.

After adding the required text, you can use the AcceptDialog or WaitForAlertAndSpecifyBehavior to continue test case execution on the main window.

Input Parameters:

Example:

WaitForAlertAndSendText      "Qualitia"          "5"          "500"        "Key"        "Defect"

WaitForAlertAndSpecifyBehavior

This action waits for the web page to prompt an alert. After the alert is prompted, you can either accept the dialog or dismiss the dialog giving appropriate values in the parameters. You may specify the timeout and polling interval, if required.

Input Parameters:

Example:

WaitForAlertAndSpecifyBehavior      "accept"          "5"          "500"        "Key"        "Defect"

MinimizeWindow

This action minimizes the window.

This action does not have any parameter. 

Example:

MinimizeWindow

SetPageLoadTimeout

This action sets the page load timeout when executing test cases. The time set here overrides the Page Timeout set in the associatedInput Parameters:

Example:

SetPageLoadTimeout             "20"

StorePageSource

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

Input Parameters:

Example:

StorePageSource             "PageSource"

StoreWindowHandleAtIndex

This action fetches the handle (identifier) of the specified window in the index and stores under the specified key.  This key can the be used in action like SelectPage and ClosePopupBrowser to work on the specific page. This action can be used when the name of the window on which user needs to work on is not known.

Input Parameters:

Example : 

StoreWindowHandleAtIndex              "Key"                   "4"

SwitchWebExecutionPlatform

This action changes the current Web execution platform from Desktop to Mobile. When used, web application test case will run on specified platform.

Input Parameters:

Example:

SwitchWebExecutionPlatform                        "Mobile"

SetWindowSize

This action sets the window size based on the parameters provided (height and width).

Input Parameters:

Example:

SetWindowSize          "1344"             "689"

StoreWindowSize

This action stores the current size of the window under the specified keys. These key values can be retrieved using the key names.

Input Parameters:

Example:

StoreWindowSize          "Height"             "Width"

SetWindowPosition

This action sets the position of the console window as per the specified position.

Input Parameters:

Example:

SetWindowPosition          "123"             "232"

StoreWindowPosition

This action stores the current position of the window under the specified keys. These key values can be retrieved using the key names.

Input Parameters:

Example:

StoreWindowPosition          "XCordinateValue"             "YCordinateValue"

SetFullScreen

This action sets the browser in the full screen mode. 

This action does not have any parameter.

Example:

SetFullScreen

ClickAndHold

This action clicks (without releasing) at the current mouse location.

This action does not have any parameter.

Example:

ClickAndHold

DoubleClick

This action performs a double click action at the current mouse location.

This action does not have any parameter. 

Example:

DoubleClick

RightClick

This action performs a right-click action at the current mouse location.

This action does not have any parameter.

Example:

RightClick

SelectFrameByIndexWhenAvailable

This action waits for the specified frame to appear on the page and selects when it is available. You may specify the timeout and polling interval, if required.

Input Parameters:

Example:

SelectFrameByIndexWhenAvailable       "3"         "10"      "500"       "Key"     "Defect" 

AnswerForNextDialog (Deprecated)

This action sets the input as the answer for the next prompt. After setting the answer, webdriver by default may cancel the prompt.

In order to accept and submit your input in the prompt, this action should be used followed by the action "AcceptDialog".

Input Parameters:

Example:

AnswerForNextDialog           "Hello"

StoreSubString (Deprecated)

This action stores a substring of a string into a variable. The key value can be retrieved using the key name. 

Input Parameters:

Example:
StoreSubString                   "resultSubString"            "This is a test"                "2"                  "4"

StoreRandomAlphanumericString

This action generates any random alphanumeric string for a specific length that you want and stores the random value for the specified key. 

Input Parameters:

Example:

StoreRandomAlphanumericString               "Key"                       "10"

StoreRoundNumber

This action stores values specified by the user by rounding them off to the nearest whole number. The rounded off value stored in the key can be retrieved using the key name.

Input Parameters:

Example:

StoreRoundNumber           "key"                 "6.43"

• In this case, 6 will be stored into the key.

StoreRoundNumber           "key"                "6.55"

• In this case, 7 will be stored into the key.

StoreRandomNumber

This action picks up any random number from the specified range and stores that number in the specified key. The key value can be retrieved using the key name.

Number can be duplicated, if you use this action multiple times in a single test case.

Input Parameters:

Example:

StoreRandomNumber        “123”         “890”        “Key”

StoreStringConcat

This action concatenates (combines) two strings specified by the user and stores into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

StoreStringConcat                "String1"          "String2"        "Key"

StoreRandomString

This action generates and stores any random string of the specified length into the key. The key value can be retrieved using the key name.

Input Parameters:

Example:

StoreRandomString               "Key"                    "23"

StoreStringFromRight

This action stores the specified number of characters from the right side of the given string. The stored key value can be retrieved using the key name.

Input Parameters:

Example:

StoreStringFromRight         "Key"      "John Doe"         "3"        

In this case, the last three characters, that is, Doe will be stored under the key name.

StoreStringFromLeft

This action stores the specified number of characters from the left side of the given string. The key value can be retrieved using the key name.

Enter 0 if you want to store the empty string.

Input Parameters:

Example:

StoreStringFromLeft     "Key"  "John Doe"    "4"    

In this case, this action stores the value of Key as John.

StoreSqRoot

This action stores the square root of the specified number under the key. The stored key value can be retrieved using the key name.

Input Parameters:

Example:

StoreSqRoot              "144"             "Key"

In this case, the 12 will be stored under key.

Example:

StoreStringFromLeft                      "John Doe"             "4"          "Key"

In this case, the first four characters i.e. Jonn will be stored under the key name.

StoreIntegerSign

This action stores an integer that indicates sign of the number specified in the parameter. The key value can be retrieved using the key name.

• If number is greater than 0, stores 1.

• If number is equal to 0, stores 0.

• If number is lesser than 0, stores -1.

Input Parameters:

Example:

StoreIntegerSign                    "Key"             "12"

If you enter a negative integer, in this case, the -1 will be stored under key because the number is lesser than 0.

StoreAbsoluteValue

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

Input Parameters:

Example:

StoreAbsoluteValue                "-3.6"              "Key"

In this case, the 3.6 will be stored under key.

StoreMatchesFromRegExPattern

This action fetches all the matches of a regular expression pattern from an InputString and stores the array of all the matches into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

StoreMatchesFromRegExPattern                  "Cust1(\d?)"               "CustKey1 CustKey123Cust321"           "Key"

Array.IsArray

This action verifies whether the specified data is in the array form. If the data is not an array, reports a defect in the execution report.

Input Parameters:

Example:

Array.IsArray              "ArrayKey"

Array.JoinArrayAndStore

This action joins the substrings from an existing array and stores them into the specified key. By default, these substrings are separated by the caret sign (^). The key value can be retrieved using the key name.

Input Parameters:

Example:

Array.JoinArrayAndStore                "ArrayKey"            "Key"

Array.Reverse

This action reverses the existing sequence of data given in an array.

Input Parameters:

Example:
Array.Reverse                     "ArrayKey"

Array.Sort

This action sorts the existing array data in an ascending order.

Input Parameters:

Example:
Array.Sort               "ArrayKey"

Array.StoreArrayLength

This action stores the length of an existing array into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

Array.StoreArrayLength       "ArrayKey"               "Key"

Array.StoreElementByIndex

This action stores the element from the specified index of an array into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:
Array.StoreElementByIndex                  "ArrayKey"          "5"           "Key"

Array.StoreElementIndex

This action stores the index of the specified element from an existing array into the specified key. The key value can be retrieved using the key name.
Input Parameters:

Example:

Array.StoreElementIndex                    "ArrayKey"           "Sunday"           "1"           "True"         "Key"

Array.VerifyElementExist

This action verifies whether the specified item exists in an array and reports a defect in case of not finding the specified item.

Input Parameters:

Example:
Array.VerifyElementExists                        "ArrayKey"             "Sunday"             "True"

LeftTrimAndStore

This action removes or trims the blank spaces existing at the extreme left side of the specified string and stores the value under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

LeftTrimAndStore         "Key"      "       John and family"            

In this case, the John and family will be stored under key. The blank space before john will be removed.

RightTrimAndStore

This action removes or trims the blank spaces existing at the extreme right side of the specified string and stores the value under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Example:

RightTrimAndStore         "Key"       "John and family           "           

In this case, the John and family will be stored under key. The blank space after john and family will be removed.

IMAGE.CompareTwoImages

This action compares two images. The file extension and resolution of both the images (source and target) should be same, otherwise, the step will fail.

Input Parameters:

Example:

IMAGE.CompareTwoImages    “C:\Users\Qualitia\Cust_Sign.png”        “C:\Users\Qualitia\Cust_Logo.png”

Date.StoreModified Date

This action modifies the date interval based on the data provided by the user and stores the modified date in the specified key. The key value can be retrieved using the key name.

Input Parameters: