Versions Compared

Old Version 34

changes.mady.by.user ravi.chandran (Unlicensed)

Saved on

compared with

New Version 35

changes.mady.by.user ravi.chandran (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page contains actions that are specific to automate Desktop applications. Also, you can use all the actions defined for General Web Actions.

OpenFirefoxBrowser

This action opens a new blank Mozilla Firefox browser.

This action does not have any input parameter.

Example:

OpenFirefoxBrowser

OpenIEBrowser

This action opens a new blank IE browser.

This action does not have any input parameter.

Example:

OpenIEBrowser

CloseAllOpenedFirefoxBrowsers

This action closes all open Firefox browsers on the desktop.

This action does not have any parameters.

Example:

CloseAllOpenedFirefoxBrowsers

CloseAllOpenedIEBrowsers

This action closes all open IE browsers on the desktop.

This action does not have any parameters.

Example:

CloseAllOpenedIEBrowsers


Table of Contents
maxLevel2
minLevel2

penURL

OpenURL

This action opens the specified URL. Qualitia user can specify the browser and browser version in the parameters section to be used when opening URL.

  • Ensure you have enabled HP Functional Testing Agent on your execution browsers (IE, Firefox, and Google Chrome).
  • Ensure the browser version installed on your execution device is compatible with HPE UFT.

Input Parameters:

Parameter Name

Parameter Description

MandatoryData Type

Browser Type

Enter the browser name in which you want to open the URL.

Parameters can be as follows:

  • IE: This will open URL in Internet Explorer.
  • Firefox: This will open URL in Mozilla Firefox.
  • Chrome: This will open URL in Google Chrome.
YesString

URL

Enter the URL to be opened.

YesString

Browser version

Enter the major and minor version of the browser installed on testing machine. For example, if browser version is 54.9.0.3323, then enter only 54.9.

NoString

Path

This parameter is applicable only when using Google Chrome browser.

Enter the absolute path of the chrome.exe from the Google Chrome installed location.

No

(for Chrome only)

String

Example:

OpenURL             “Chrome”  “http://www.google.com”     “53.8”   “C:\Program Files\Google\Chrome\Application\chrome.exe”

When using this action, 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.


CloseApplication

This action closes the specified application.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Processname

Process Name of the application that is to be closed.

Yes

String

Example:
CloseApplication             "notepad.exe"

ExecuteDDLQueryAndStoreInFile

This action executes data definition queries like select and stores the result set of the fired query. The result set is stored in a CSV file. The action supports and is tested for database Oracle 10g.

Before using this action, ensure that the required database and database drivers are installed. Below is basic information on the oracle drivers and connection with Vbscript.

Oracle10g:

For interacting with the database you would need a driver that is supported in VbScript to interact with Oracle 10 g. One of the drivers can be as follow. The driver would need to be installed before interacting with the database.

  • Driver - "Oracle in OraDb10g_home1".
    You would need to know the following details as well.
  • Database  Name- is the oracle database to which the user wishes to connect.
  • User ID – The username to connect to the database
  • Password - The password to connect to the database

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

driver

The driver for the database

Yes

String

dB

The database name on which the query will be fired

Yes

String

username

The user name to connect to the database

Yes

String

password

The password to connect to the database

Yes

String

query

The query that needs to be executed. This keyword is design such that it can store result set. Hence this keyword is beneficial for SQL queries that can return result set

Yes

String

filename

The complete path of the file in which the results of the database query is to be stored

Yes

String

Example:
ExecuteDDLQueryAndStoreInFile                    "Oracle in OraDb10g_home1"       "ORCL"        "system"          "admin"             "Select * from sales_master where id=100" "{Key_SQL13_InwardRegisterControl_ActData_FilePath}"

ExecuteDMLQueryAndStoreInKey

This action executes data manipulation queries like update, delete, and stores the result into a key. This action supports and is tested for database Oracle 10g.

Before using this action, ensure that the required database and database drivers are installed. Below is basic information on the oracle drivers and connection with Vbscript.

Oracle10g:

For interacting with the database you would need a driver that is supported in VbScript to interact with Oracle 10 g. One of the drivers can be as follow. The driver would need to be installed before interacting with the database.

  • Driver - "Oracle in OraDb10g_home1".
    You would need to know the following details as well.
  • Database  Name- is the oracle database to which the user wishes to connect.
  • User ID – The username to connect to the database
  • Password - The password to connect to the database

Input Parameters

Parameter Name

Parameter Description

Mandatory

Data Type

driver

The driver for the database

Yes

String

url

The connection string to connect to the database, basically the server address

Yes

String

username

The user name to connect to the database

Yes

String

password

The password to connect to the database

Yes

String

query

The dml query that needs to be executed

Yes

String 

key

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

Yes

String

Example:

ExecuteDMLQueryAndStoreInKey              "Microsoft ODBC for Oracle"       "Server=localhost"      "system"       "admin"        "Update * from sales_master where id=100" "{Key_Status}"

CalculateDifferenceInDateAndStore

This action stores the difference between two specified dates under the specified key. The key value can be retrieved using the key name.

Input Parameters:


Parameter Name

Parameter Description

Mandatory

Data Type

strKey

The key in which the difference will be stored.

Yes

String

interval

It is the expression that you want to use to calculate the differences between from date and to date. Please refer to the Interval section below for more examples of it.

Yes

String

fromDate

Enter the date from.

Yes

Integer

toDate

Enter the date to.

Yes

Integer


(info) Interval: The interval parameter can have the following values:


Parameter

Description

YYYY

Year

Q

Quarter

M

Month

Y

Day of year

D

Day

W

Weekday

WW

Week of year

H

Hour

N

Minute

S

seconds


Example:
CalculateDifferenceInDateAndStore      "Key"            "D"        "12-Dec-2016"      "12-Dec-2027"

NavigateFireFoxBrowser

This action opens the specified URL in the Mozilla Firefox browser. If there is any blank firefox browser on the desktop, uses the same browser, otherwise Qualitia opens a new blank browser and navigates to the URL.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strURL

Enter the URL to open.

Yes

String

Example:

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

NavigateIEBrowser

This action opens the specified URL in the Internet Explorer (IE) browser.  If there is any blank IE browser on the desktop, uses the same browser, otherwise Qualitia opens a new blank browser and navigates to the URL.

This browser can be used in conjunction with OpenIEBrowser action.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strURL

Enter the URL to open.

Yes

String

Example:

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

OpenApplication

This action opens the application with specified path.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strPath

Enter the absolute path of the application to be opened.

Yes

String

Example:

OpenApplication "C:\WINDOWS\system32\notepad.exe"


PressKey

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

 strKey

Enter the key to be pressed from the keyboard. 

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 PressKey .The data to be passed to the keyword in this case will be given as ~^F where ^ means Control. (See the list below for the keys and their meaning.

The action returns 0, if the key is pressed successfully, otherwise, 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 caret for the following characters which has a special meaning in Qualitia. These characters are {,}, ^.

For example, if you want to press the {F1} key, then user should pass data as {F1}

Use the PressKey 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, if you want to send the letter x, send the string argument "x".

You can use PressKey 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 PressKey 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             "^",
  • percent sign "%",
  • 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 PressKey, but you must enclose them within braces to accommodate applications that do give them a special meaning (for dynamic data exchange (DDE)).

  • 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:  ^
  • ALT:  %

(warning) 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".

You can use the PressKey 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.

Info
  • 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 " ".

SAPAutoLogon

This action connects and logs on to the designated SAP server.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ServerDescription

Enter the server details that need to be connected.

Yes

String

Client

Enter the client details that need to be connected.

Yes

String

User

Enter the User name to use when connecting to the server.

Yes

String

Password

Enter the password to use when connecting to the server.

Yes

String

Language

Enter the 2-digit code to select the language.

Yes

String


Example:

SAPAutoLogon                      "Calderone"         "4700"       "Qualitia"        "Password"       "EN"

SAPAutoLogonByIP

This action connects and logs on to an SAP server according to its IP address.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ConnectionString

Enter the connection string that needs to be connected.

Yes

String

Client

Enter the client details that need to be connected.

Yes

String

User

Enter the User name to use when connecting to the server.

Yes

String

Password

Enter the password to use when connecting to the server.

Yes

String

Language

Enter the 2-digit code to select the language.

Yes

String


Example:

SAPAutoLogonbyIP               "/F/123.132.75.5/S/3200"        "4700"              "Qualitia"          "Password"        "EN"

SAPAutoLogonByTargetSystem

This action connects and logs on to an SAP server according to specified target system.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

TargetSystem

Enter the target system that needs to be connected.

Yes

String

Client

Enter the client details that need to be connected.

Yes

String

User

Enter the User name to use when connecting to the server.

Yes

String

Password

Enter the password to use when connecting to the server.

Yes

String

Language

Enter the 2-digit code to select the language.

Yes

String


Example:

SAPAutoLogonbyIP            "C5P"            "3200"          "4700"       "Qualitia"        "Password"       "EN"

SAPCloseConnections

This action closes all the existing connections that are open currently.

This action does not have any input parameters.

Example:
SAPCloseConnections

SAPOpenConnection

This action opens the connection to the specified SAP server.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ServerDescription

Enter the server description that needs to be connected.

Yes

String

Example:

OpenConnection            "Calderone"

SAPOpenConnectionByIP

This action opens a connection to the specified SAP server according to its IP address.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ConnectionString

Enter the connection string that needs to be connected.

Yes

String


Example:
OpenConnectionByIP                "/F/123.132.75.5/S/3200"

SAPOpenConnectionByTargetSystem

This action opens a connection to the specified SAP server according to its target system.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

TargetSystem

Enter the target system that needs to be connected.

Yes

String


Example:
OpenConnectionByIP          "C5P"

SAPStartBPCATracing

This action begins running the Business Process Change Analyzer to detect changes in a transaction's objects (as compared to the TBOM).

This action does not have any input parameters.

Example:

SAPStartBPCATracing

SAPStopBPCATracing

This action stops the Business Process Change Analyzer.

This action does not have any input parameters.

Example:

SAPStopBPCATracing

StoreArrayItem

This action gets the value from an array and stores it into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameters Name

Parameter Description

Mandatory

Data Type

Key

Enter the key in which the Array is to be stored.

Yes

String

ArrayName

Enter the array name from which values are to be stored.

Yes

String

ArrayIndex

Enter the array index from which values are to be stored.

Yes

String

Example:

StoreArrayItem            "Key"          "Name"          "3"

StoreObjectInstanceCount

It stores the total number of children of desktop class for the given set of arguments in a given key. Argument key and value should be separated by '=' and multiple key/val pair should be separated by a comma ','.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ObjectDescription

Specification/property of the object whose instance count is to be stored.
A general format is :"key1=value1,key2=value2,key3=value3"

Yes

String

Key

The key in which count is to be stored.

Yes

string

Example:
StoreObjectInstanceCount                 "Class Name=JavaWindow,title=LibrarySystem"             "MyObjInstanceCountKey"


StoreSplitString

This action splits the string based on the delimiter specified by the user. Any of the split items can be stored, the particular item that is to be stored the user should provide the index of that item.

Input Parameters:


Parameter Name

Parameter Description

Mandatory

Data Type

strKey

The variable in which the specified indexed item of the split string is to be stored

Yes

String

mainString

The string which is to be split

No

String

delimiter

The delimiter to be used for splitting

Yes

String

instance

The index of the item which is to be store after splitting

 No

String


Example:

StoreSplitString             "StoreItem"          "This is ; a sample ; String"            ";"               "2 "


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

key

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

Yes

String

sourceString

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

No

String

startIndex

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

No

String

endIndex

The number of characters required in the string.

No

String


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

StoreStringLength

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

key

A key in which a length will be stored

Yes

String

mainstring

A string from which a length will be derived

No

String

intvValue

The value by which the length needs to be incremented.

No

Integer

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

WaitFor

This action makes a tool wait for the specified period of time.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

intExpTimeSecs

'intExpTimeSecs' is the specified seconds that the tool is expected to pause.

Yes

Integer

Example:
Waitfor            "8"

WriteLog

This action helps Qualitia users to select the appropriate status and information message to be displayed in the execution report based on the test case requirements.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Status

Enter the result status to be displayed in the report. The report status should be Pass, Fail, or Defect.

Yes

String

Message

Enter the message to be displayed for the respective test step in the execution report.

Yes

String

Example:

WriteLog                        "Defect"                    "The value in the edit box should be Username"

WriteTextToFile

This action allows users to write or append the text in the specified file.

(info) User performing this action should have write access to the corresponding file and folder.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

FileName

Enter the absolute path to the file in which you want to make changes.

Yes

String

FileContent

Enter the content to be overwritten or appended.

Yes

String

Mode

Value of this parameter can be OVERWRITE or APPEND. If user keeps mode empty, it will be considered as append.

Yes

String

Example:
WriteTextToFile                  "C:\Users\Notepad.txt"          "Qualitia"            "Append"


Date.StoreModifiedDate

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

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Inputdate

Enter the date to which you want to add the interval.

Yes

String

Interval

Enter the interval which you want to modify. Value for this parameter can be as follows:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of year
  • d - Day
  • w - Weekday
  • ww - Week of year
  • h - Hours
  • n - Minutes
  • s – Seconds

Yes

String

Data

Enter the number of intervals you want to add to the input date. The number can be positive for future dates and negative for dates in the past.

YesInteger
Key

Enter the key name under which you want to store the modified date. The key value can be retrieved using the key name.

YesString

Example:

Data.StoreModifiedDate “02/28/2001”     “yyyy”    “10”    “Key”

Post execution, Qualitia will store 02/28/2010 in the key.

Date.ChangeDateFormat

This action modifies format of the date and time based on the format specified by the user and stores the date and time in the modified format under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Inputdate

Enter the date whose format you want to change.

Yes

String

Interval

Enter the value for the format you want to update the date into. Value for this parameter can be as follows:

  • 0 – Converts current date into mm/dd/yy and time (if specified) into hh:mm:ss PM/AM.
  • 1 – Converts current date into weekday, monthname, year format.
  • 2 – Converts current date into mm/dd/yy format.
  • 3 – Converts current time into hh:mm:ss PM/AM format
  • 4 - Converts current time into hh:mm format.

Yes

String

Key

Enter the key name under which you want to store the modified date. The key value can be retrieved using the key name.

YesString

Example:

Date.ChangeDateFormat           “02/28/2001”     “1”    “Key”

Post execution, Qualitia will store Monday, February, 2010 in the key.

DB.ExecuteDDLQueryAndStoreInFile

This action executes Data Definition Language (DDL) queries and stores the result set of the fired query in a text file.

Info
titlePrerequisite:

Before using this action, ensure that the required databases and database drivers are installed.


Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ConnectionString

The ConnectionString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

FilePath

Enter the absolute path to the file in which you want to store the results.

YesString

Example:

  • MySQL:

DB.ExecuteDDLQueryAndStoreInFile       “DRIVER=~{MySQL ODBC 5.3 ANSI Driver~};Server=192.168.24.99,1234; Database=ProductInfo;UID=Qualitia; PWD=Qualitia”       "select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"        "C:\Users\localadmin\Desktop\ProductInfo.txt"

  • MS SQL:

DB.ExecuteDDLQueryAndStoreInFile       “DRIVER=~{SQL Server~}; Server=192.168.24.99,1234;Database=ProductInfo UID=Qualitia;PWD=Qualitia”       "select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"        "C:\Users\localadmin\Desktop\ProductInfo.txt"

DB.ExecuteDMLQueryAndStoreinKey

This action executes Data Manipulation Language (DML) queries such as update, delete and so forth and stores the query execution status into the specified key. If the query gets executed successfully, stores 0 and if the query does not get executed, stores 1.

Info
titlePrerequisite:

Before using this action, ensure that the required databases and database drivers are installed.


If the record set has more than one records, value cannot be stored under the specified key. In such cases, this action fails showing appropriate error logs in the test case execution reports.


Parameter Name

Parameter Description

Mandatory

Data Type

ConnectionString

The ConnectionString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

Key

Enter the key under which you want to store the results. Key value van be retrieved using the key name.

YesString

Input Parameters:

Example:

  • MySQL:

DB.ExecuteDMLQueryAndStoreInKey          “DRIVER=~{MySQL ODBC 5.3 ANSI Driver~};Server=192.168.24.99,1234; Database=ProductInfo;UID=Qualitia; PWD=Qualitia”

"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"      "ProductInfo"

  • MS SQL

DB.ExecuteDMLQueryAndStoreInKey          “DRIVER=~{SQL Server~}; Server=192.168.24.99,1234;Database=ProductInfo UID=Qualitia;PWD=Qualitia”

"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"      "ProductInfo"

DB.ExecuteDDLQueryandStoreDatainKey

This action executes Data Definition Language (DDL) queries and stores the result data set in the specified key. In case of finding multiple data sets, this action will fail.

Info
titlePrerequisite:

Before using this action, ensure that the required databases and database drivers are installed.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

ConnectionString

The ConnectionString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

Key

Enter the key under which you want to store the results. Key value van be retrieved using the key name.

YesString

Example:

  • MySQL:

DB.ExecuteDDLQueryandStoreDatainKey         “DRIVER=~{MySQL ODBC 5.3 ANSI Driver~};Server=192.168.24.99,1234; Database=ProductInfo;UID=Qualitia; PWD=Qualitia”

"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"       "ProductInfo"

  • MS SQL:

DB.ExecuteDDLQueryandStoreDatainKey         “DRIVER=~{SQL Server~}; Server=192.168.24.99,1234;Database=ProductInfo UID=Qualitia;PWD=Qualitia”

"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'"       "ProductInfo"


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:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the key name in which you want to store the updated string.

Yes

String

InputString

Enter the string whose case you want to change.

Yes

String

Case

Value for this parameter can be as follows:

  • Set Upper to change the case of the string to upper case.
  • Set Lower to change the case of the string to lower case.

Yes

String

Example:

ChangeCaseAndStore                "Key"               "Qualitia"             "Upper"

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:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the key name in which you want to store integer value.

Yes

String

Number

Enter the number whose integer value you want to store into the key.

Yes

String

Example:

StoreStringToInteger            "Key"          "20"

unchApplication




LaunchApplication

This action runs the application or file from the specified path.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

filePath

Enter the absolute path of the application or file which you want to run or open.

Yes

String

AppParameters

If the filePath contains path to the executable file, enter the argument here to specify any parameters to be passed while opening the file.

No

String

AppDirectoryPath

Enter the directory of the application or executable file.

No

String

Operation

Specify the operation to performe after opening the application. You can specify following operations:

  • Open-Opens the specified file or application. This can be an executable file or folder as well.
  • Edit-Launches the application or file in the edit mode.
  • Explore-Explores the folder which is specified in the filePath parameter.
  • Find-Initiates the search operation from the specified folder path.
  • Print-Prints the file specified in the filePath parameter. This action fails in case the file is not printable.
    Default value is Open.

No

String

Mode

Enter the mode of the application or file to open. You can specify the integer value from the list below to open application in corresponding mode.
Enter,

  • 0 to hide the window.
  • 1 to activate and display the window of the application or file which is launched.
  • 2 to open the application window in minimize mode.
  • 3 to open the application window in maximize mode.
  • 4 to open the application window in its most recent size and position.
  • 5 to open the application window in its current size and position.
  • 6 to minimize the specified window and activate the next top-level window in the Z order.
  • 7 to display the window as a minimized window.
  • 8 to displays the window in its current state.
  • 9 to activate and display the window. If the window is minimized or maximized, the system restores it into its original size and position.
  • 10 to Set the show-state based on the state of the program that started the application.
    Default value is 1.

No

Integer


Example:

LaunchApplication                "C:\Application.exe"

TypeKey

This action simulates the keystroke events specified into the parameter.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the keys which you want to simulate.

Yes

String

This action supports following keystrokes:

To pressEnter
tab key"Tab"
enter key"Enter"
F1 key"F1"
F2 key"F2"
F3 key"F3"
F4 key"F4"
F5 key"F5"
F6 key"F6"
F7 key"F7"
F8 key"F8"
F9 key"F9"
F10 key"F10"
F11 key"F11"
F12 key"F13"
space key"Space"
CapsLock key"CapsLock"
delete key"Delete"
down arrow key"Down"
up arrow key"Up"
right arrow key"Right"
left arrow key"Left"
end key"End"
home key"Home"
page down key"Page_Down"
page up key"Page_Up"
shift key"Shift"


Example:

TypeKey       "Enter"


TypeString

This action simulates the keyboard inputs specified into the parameters.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Text

Enter the string which you want to type.

Yes

String

Example:

TypeString        "qualitiasoft.com"


DoubleClick

This action double clicks at the specified location of the screen or object from the application under test.

Input Parameters:


Parameter Name

Parameter Description

Mandatory

Data Type

x-coordinate

Enter the x-coordinate of the screen where you want to perform double click.

Yes

Integer

y-coordinate

Enter the y-coordinate of the screen where you want to perform double click.

No

Integer

 Button

Specify which button of the mouse you want to press while performing the double click action. Valid parameters are left, middle, and right. Default is left.

No

String


Example:

DoubleClick         “233”             “342”          “Left”