Document toolboxDocument toolbox

A new version of Qualitia Automation Studio for Web and Mobile 7.2.x is now available. We highly recommend you upgrade. Find more details here.

General Web Actions

OpenURL

This action opens the specified URL in the browser selected under Configuration Settings.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

url

Enter the URL that you want to open.

Yes

String

Example:

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

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

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:

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter the key name to store URL.

Yes

String

Example:

StorePageURL                   "Key"

StorePageTitle

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter the key name to store page title.

Yes

String

Example:

StorePageTitle                   "Key"

StoreVariable

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter the key name to store variable.

Yes

String

data

Enter the value to be stored under the key name.

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable under which the string data is to be stored.

Yes

String

data

Enter the data to be stored in encrypted mode.

Yes

String

Example:

SecureStoreVariable              "Password"                               "Encrypt(Abc)"

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

On this page:

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:

Parameter Name

Parameter Description

Mandatory

Data Type

seconds

The number of seconds to wait for

No

String

Example:
Sleep                   "20"

SelectPage

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

windowName

Enter the name of the window which you want to select. You may use "NULL" to select the main window.

Yes

String

Example:

Select Page                            "Name"

ClosePopUpBrowser

This action closes the popup appeared on the web page. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

windowName

Enter the name of the window that you want to close.

Yes

String

Example
ClosePopUpBrowser                   "viewPage"


PressKeys

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

This action is applicable only for desktop web applications.

This action does not work when executing test cases in remote environment. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strKey

Enter the key which you want to press from the key board. 

Yes

String

Example:

Suppose the user want to open the Find dialog on the Browser window under test. Manually this is done by pressing the keys Control and F simultaneously. This opens the Find dialog on the browser window. The same thing can be done using the action PressKeys .The data to be passed to the action in this case will be given as ~^F where ^ means Control. (See the list below for the keys and their meaning.

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

Important Note:

Ideally the data to be passed here is only ^F, however as ^ has a special meaning in Qualitia it has to be preceded with an escape sequence ~. Hence the data passed will be ~^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 {,}, ^, ~


Ex:

  1. If key to be sent is {F1} then user should pass data as ~{F1~}
  2.  To send {TAB} then user should pass data as ~{TAB~}
  3.  To send {ENTER} user should pass data as ~{ENTER~}

Use the PressKeys method 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 would send the string argument "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 escape character (~))
  • percent sign "%",
  • and tilde       "~"

Send these characters by enclosing them within braces "{}". For example, to send the plus sign, send 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, send the string argument "{[}" for the left bracket and "{]}" for the right one.
  • To send brace characters, send the string argument "}" for the left brace and "{" for the right one.

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, send the arguments shown in the following table:

Key

Argument

BACKSPACE

~{BACKSPACE~}, ~{BS~}, or ~{BKSP~}

BREAK

~{BREAK~}

CAPS LOCK

 ~{CAPSLOCK~}

DEL or DELETE

~{DELETE} or ~{DEL~}

DOWN ARROW

~{DOWN~}

END

~{END~}

ENTER

~{ENTER~} or ~

ESC

~{ESC~}

HELP

~{HELP~}

HOME

~{HOME~}

INS or INSERT

~{INSERT~} or ~{INS~}

LEFT ARROW

~{LEFT~}

NUM LOCK

~{NUMLOCK~}

PAGE DOWN

~{PGDN~}

PAGE UP

~{PGUP~}

PRINT SCREEN

~{PRTSC~}

RIGHT ARROW

~{RIGHT~}

SCROLL LOCK

~{SCROLLLOCK~}

TAB

~{TAB~}

UP ARROW

~{UP~}

F1

~{F1~}

F2

~{F2~}

F3

~{F3~}

F4

~{F4~}

F5

~{F5~}

F6

~{F6~}

F7

~{F7~}

F8

~{F8~}

F9

~{F9~}

F10

~{F10~}

F11

~{F11~}

F12

~{F12~}

F13

~{F13~}

F14

~{F14~}

F15

~{F15~}

F16

~{F16~}

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 do this by preceding the regular keystroke with one or more of the following special characters:
Key  Special Character
SHIFT  +
CTRL  ^ (Use with escape character (~))
ALT  %
Note: 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, send the string argument "+(ec)".
  • e is pressed, followed by a lone c (with no SHIFT), send the string argument "+ec".
  • If you want to send a key combination that includes Ctrl key, send it like this: to send Ctrl + N send "~^n".

You can use the PressKeys method 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. You do this using 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}". Be sure to include a space between keystroke and number.

  • The only keystroke pattern you can send is the kind that is comprised of a single keystroke pressed several times. For example, you can send "x" ten times, but you cannot do the same for "Ctrl+x".
  • You cannot send the PRINT SCREEN key ~{PRTSC~} to an application.
  • To send a space, send the string " ".

StoreSubString

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strKey

The variable in which the sub-string is to be stored.

Yes

String

strMainString

Enter the string whose sub-string value is to be stored.

Yes

String

intStart

Enter the index of the string from where the sub-string is to be fetched.

Yes

String

intLength

The number of characters required in the string.

Yes

String


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

StoreStringLength

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strKey

The variable in which the length of the string is to be stored

Yes

String

strMainString

The string whose length is to be stored

Yes

String

intIncrement

The value by which the length needs to be incremented

Yes

String

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

CompareString

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 CompareString function will retrieve the value from the key and that value will be compared with expected.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

firstString

Enter the 1st string value that you want to compare. You can pass the key name here enclosed in braces.

Yes

String

mainString

Enter the 2nd string value that you want to compare. You can pass the key name here enclosed in braces.

Yes

String

caseSensitive

Specify the kind of comparison; case-sensitive or case-insensitive.

  • Set True for case-sensitive comparison.
  • Set False for case-insensitive comparison.

Yes

String

Example:
StoreVariable             "Cancel"           "key"

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).

The action can also compare strings having a new line character.
The spaces of both the strings are trimmed before comparing.


VerifyStringContainsValue

This action verifies that the substring is present within the main string. Comparison can either be case sensitive or insensitive.

This action verifies that the substring is present within the main string. Comparison can either be case sensitive or insensitive.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

MainString

Enter the main string in which you want to search substring. You can pass the key name here enclosed in braces.

Yes

String

Substring

Enter the 2nd string value that you want to search. You can pass the key name here enclosed in braces.

Yes

String

caseSensitive

Specify the kind of comparison; case-sensitive or case-insensitive.

  • Set True for case-sensitive comparison.
  • Set False for case-insensitive comparison.

Yes

String

Example:
StoreVariable                           "Testing the action"                   "mainStrKey"

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

Here 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 will return 0, if the sub-string is found in the main string, else it will return 2 if the sub-string is not found in the main string. In any other case it will return 1.

Empty and null sub-strings will not be 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:

Parameter Name

Parameter Description

Mandatory

Data Type

Pattern

Enter the pattern against which the data specified by the user will be verified.

Yes

String

Data

Enter the data which will be matched against the pattern specified by the user.

Yes

String

caseSensitive

Specify the kind of comparison; case-sensitive or case-insensitive.

  • Set True for case-sensitive comparison.
  • Set False for case-insensitive comparison.

Yes

String

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]/{5/}[0-9]/{5/}$
  • strData –  YuIFp96062
  • blnCase -    False

ComparePattern                 "/^[a-z]/{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.

VerifyDifference

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Int1

Enter the 1st numerical value to compare. You can pass the key name here enclosed in braces.

Yes

String

Int2

Enter the 2nd numerical value to compare. You can pass the key name here enclosed in braces.

Yes

String

difference

Enter the expected difference between the two numbers.

Yes

String

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.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strKey

Enter the key name under which instance of the split string will to be stored.

Yes

String

mainString

Enter the string which you want to split.

Yes

String

Delimiter

Enter the delimiter which you want to use while splitting the mainString. This can be any alphanumeric or special character.

(info) If the delimiter is a java special character, ensure you escape the character using backslash (\) prior to the delimiter character.

In case there are multiple delimiter characters in the mainString, it stores string backwardly from the specified delimiter up to the next instance of the delimiter character. (see example for more details)

Yes

String

instance

Enter the occurrence of the item which you want to store under the specified key. The instance starts from 1.

Yes

String

Example:

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

Here, the delimiter is =, as there are multiple occurrences of =in the mainString,,  after this action is executed, the text between 2nd and 1st delimiter character (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:

Parameter Name

Parameter Description

Mandatory

Data Type

locator

Enter the locator using which you want to select the frame. This parameter can have the values of the frame's: ID, Name, Xpath, CSS.

Yes

String

locatorType

Enter which locator type you want to use. It can be ID, Name, xpath, CSS and so on. In order to come out of all the frames, the parameters passed should be empty.

Yes

String

Example:

SelectFrame                        "mainFrame"               "name"

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:

Parameter Name

Parameter Description

Mandatory

Data Type

Format

Enter the format which you want to use to save the date. Use DD for day, MM for month and YYYY for year. 
For example: dd/MM/yyyy , MMM/dd/yyyy , dd-MM-yyyy.  
dd = day 
MM = month represented as 01,02,03 etc 
MMM = month represented as Jan. Feb, Mar etc 
yyyy = year

Yes

String

key

Enter the key name under which you want to store the current date.

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

date

The date which needs to be stored in the specified format.

Yes

String

Format

Enter the format using which you want to save the date. Use DD for day, MM for month and YYYY for year.

For example: dd/MM/yyyy , MMM/dd/yyyy , dd-MM-yyyy, and so on.
dd = day 
MM = month represented as 01,02,03 etc 
MMM = month represented as Jan. Feb, Mar etc 
yyyy = year

Yes

String

resultFormat

Format in which the date given by the user needs to be stored.

Yes

String

key

Enter the key name under which the new result will be stored.

Yes

String

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

VerifyDates

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

startDate

Enter the start date which needs to be verified.

Yes

String

startformat

Enter the format of the start given date.

Yes

String

endDate

Enter the end date which needs to be compared with the start date.

Yes

String

endFormat

Enter the format of the end given date.

Yes

String

operation

Specify the operation to be performed between the first and second dates.

  • Use < to verify that the first date is less than (comes before) the second date.
  • Use > to verify that the first date is greater than (comes after) the second date.
  • Use == to verify that the dates are equal.
  • Use != to verify that the dates are unequal.

Yes

String

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"               "<"

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. 

Date Time Formats Examples
dd-MM-yy 31-01-12 
dd-MM-yyyy31-01-2012
MM-dd-yyyy01-31-2012
yyyy-MM-dd 2012-01-31
yyyy-MM-dd hh:mm:ss 2012-01-31 23:59:00 
yyyy-MM-dd hh:mm:ss.SSSZ2012-01-31 23:59:59.999+0100 
EEEEE MMMMM yyyy HH:mm:ss.SSSZSaturday November 2012 10:45:42.720+0100

You can create your own combinations and formats using the patterns mentioned here. These patterns mentioned herein are case-sensitive. Ensure you use them in a correct way in order to achieve the desired output. 

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:

Parameter Name

Parameter Description

Mandatory

Data Type

date

Enter the date that needs to be updated.

Yes

String

format

Enter the format of the date given by the user.

Yes

String

dayValue

Enter the value by which you want to increase/decrease the day. For example; "1", "-3".

Yes

String

monthValue

Enter the value by which you want to increase/decrease the month. For example; "1", "-3".

Yes

String

yearValue

Enter the value by which you want to increase/decrease the year. For example; "1", "-3".

Yes

String

key

Enter the key name under which the updated date will be stored. 

Yes

String

Example:
To change date from 1st 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:

Parameter Name

Parameter Description

Mandatory

Data Type

startDate

Enter the start date to compare.

Yes

String

startformat

Enter the date format of the start date.

Yes

String

endDate

Enter the end date to compare.

Yes

String

endFormat

Enter the date format of the end date.

Yes

String

key

Enter the key name under which the difference (in days) will be stored. 

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

existence

Value of this parameter can be true or false.

  • Set True if you want to check for the presence.
  • Set False if you want to check for the absence.

Yes

String

Example:
VerifyDialogExistence                       "True"

AnswerForNextDialog

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:

Parameter Name

Parameter Description

Mandatory

Data Type

answer

Enter the input which you want to set in the next prompt.

Yes

String

Example:

AnswerForNextDialog           "Hello"


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:

Parameter Name

Parameter Description

Mandatory

Data Type

key

Enter the key name under which you want to save the message.

Yes

String

Example:

StoreDialogText               "message"

ExecuteFile

This action executes the batch file specified by the user.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

batchFile

The absolute path to the batch file to be executed. Path should not have whitespace.

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

fileInputlocator

Enter the locator of the input box where the file is to be selected.

Yes

String

locatorType

Enter the type of locator used for the locator of the file input object. 
This could be Id, xpath, name, CSS.

Yes

 String

filePath

Enter the absolute path of the file. 

Yes

String

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

ExecuteQueryAndStoreInFile

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

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

  1. For text file - .txt
  2. For xml file- .xml
  3. For excel file- .xls

The databases tested are my sql 5.1, Oracle 10g,MS Access, SQL Server 2008.

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 

2. 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 

3. 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 

4. 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:

Parameter Name

Parameter Description

Mandatory

Data Type

Driver

Enter the driver for the database.

Yes

String

url

Enter the connection string to connect to the database.

Yes

String

username

Enter the user name to connect to the database.

Yes

String

Password

Enter the password to connect to the database.

Yes

String

Query

Enter the ddl query that needs to be executed.

Yes

String

File

Enter the absolute path of the file in which the results of the database query need to be stored.

Yes

String

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.

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 

2. 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 

3. 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 

4. 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:

Parameter Name

Parameter Description

Mandatory

Data Type

Driver

Enter the driver for the database.

Yes

String

url

Enter the connection string to connect to the database.

Yes

String

username

Enter the user name to connect to the database.

Yes

String

Password

Enter the password to connect to the database.

Yes

String

Query

Enter the dml query that needs to be executed.

Yes

String

key

Enter the key in which the result of the database query need to be stored.

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

firstFile

The complete location of the first file to be compared

Yes

String

secondFile

The complete location of the second file to be compared

Yes

String

resultFileType

The file type in which the difference between the two results need to be displayed. The file type supported is: 
MSExcel 

No

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

expression

The expression to be evaluated

Yes

String

strKey

The key under which the result of the evaluation will be stored.

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

firstArray

The first array whose items are separate by carat (^) operator.

No

Array

secondArray

The second array whose items are separate by carat (^) operator.

No

Array

match

This parameter specifies the type of comparison to be done. It can be one of the following: 

  • Exact – This will compare the items of the array for exact match that is size of the two arrays should match. The sequence in which the items occur in the arrays should match. This is a one to one comparison. 
  • Partial- This compares if the second array is a sub-list of the first. The sub-list items in the second array need not be in the same sequence as they appear in the first array. However, it is not vice versa, that is, it will not check if the first array is a sub-list of the seconds array. In this case, the action will fail.

No

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

strKey

The key on which the handle of the window need to be stored

Yes

String

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:

Parameter Name

Parameter Description

Mandatory

Data Type

Link

The locator of the link to be verified. This is the inner text of the link.

Yes

String

Example:
VerifyLinkOnPage                    "AdvancedSearch"


DragAndDropToObject

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

dragLocator

Enter the locator value of an element to be dragged.

Yes

String

dragLocatorType

Enter the locator type of the element to be dragged.

Yes

String

dropToLocator

Enter the locator of an element whose location (i.e., whose centre-most pixel) will be the point where dragLocator is dropped.

Yes

String

dropToLocatorType

Enter the locator type of the element where the element will be dragged.

Yes

String

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


WindowsAuthenticationLogin

This action helps to login into the application using the basic Windows authentication. It is supported on Internet Explorer, Google Chrome, and Mozilla Firefox browsers on desktop Web only.

Selenium does not support operations on such windows out-of-the-box when the browser is set to Internet Explorer. In order to achieve this condition on Internet Explorer browser, you must first install AutoIT to interact using Windows authentication.

All the actions dependent on AutoIT are sensitive to the object focus.

  1. Download AutoIt v3.
  2. Choose Full Installation.
  3. After the setup is completed, set the AutoIT installation folder path in Qualitia Configuration Settings.
    1. Log on to Qualitia Automation Studio. 
    2. On the File menu, click Setting > Configuration Setting > Dependency.
    3. In AutoITInstall Path, select the AutoIT installation folder path. 
      For example:C:\Program Files\Auto IT or C:\Program Files(x86)\Auto IT

    4. Click OK.


Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

url

Enter the URL to the web application.

Yes

String

Username

Enter the username to sign in.

Yes

String

Password

Enter the password to sign in.

Yes

String

Example:

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

(warning) This action is tested on IE 11, Chrome 71, and Firefox 63.

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:

Parameter Name

Parameter Description

Mandatory

Data Type 

locator

The xpath of the object whose child count is to be retrieved.

It is mandatory that the input should be an xpath locator. This action will fail for any other locator type.

Yes

String

key

Enter the key name under which the count will be stored.

Yes

String

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


DownloadFile

This action clicks the link/element which will populate a download window, and then downloads the file.

The action supports and is explicitly tested for FF3, IE7, IE8. The action will not wait till the file is downloaded, this has to be handled externally by the user.

This action requires AutoIt to be installed.

  1. Install AutoIT from the location http://www.autoitscript.com/site/autoit/downloads/
  2. Click on Download AutoIt v3.
  3. Choose full installation.
  4. After the set up is completed, AutoIT installation path should be set against the Qualitia's configfile key "AutoITPath"

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

folderName

The path where the file is to be download. Please check Table 1 "Parameter Mandate" to validate in the situation where this parameter will be mandatory. In case the parameter Mandatory; the user should take care that the folder path exists. The action does not validates whether the folder exist

Yes

String

Filename

The filename of the downloadable file, to be given incase the user requires to give specific name and not depend on the default name of the file. In case, the file already exist, similar window like below will appear. Such windows are not handled by the action. Incase, the user does not provide this data, the action will pick the default file name available while download.

No

String





Example 
DownloadFile               "C:/ProgramData"              "Qualitia" 
(warning) This action is tested on IE8, FF & chrome. This action is not supported on IE9, IE10, and Google Chrome <16.

WaitForPageToLoad

This actions waits for the page to load for the specified number of seconds. If the wait time is "" then the wait time value is taken from the "Sync Time" set under the Qualitia Configuration (Execution) window. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

waitTime

Enter the number of seconds to wait.

Yes

String

Example:
WaitForPageToLoad                        "10"

In Webdriver, we wait for the object to come in ready state. If it is in ready state it is assumed that the page is loaded completely and Webdriver will stop waiting. The condition to wait till the object is in ready state and assume that the page is loaded could however not work as expected at all times.

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:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the key in which the message will be stored.

Yes

String

Example:
AcceptDialogAndStoreMessage                  "AlertMessage"

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:

Parameter Name

Parameter Description

Mandatory

Data Type

propertyName

Property name to be written in qer.properties file

Yes

String

propertyValue

Property value to be written in qer.properties file

Yes

String

Example:
WriteToBuildProperty             "propertyName"                 "propertyValue"

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 parameter. 

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

Not finding what you need?