Parameterization

Parameterization

Parameterization is a feature in Qyrus which enables users to pass data to their scripts through external xlsx files or datatables. Parameterization can be achieved by marking a step as 'Parameterized', this term denotes that the data for that particular step is being picked up from external xlsx parameter file or datatable for that particular environment. Users can leverage this option and mark multiple steps as parameterized in the Test Steps page. Ultimately users will be able to provide different data for each step per execution through the parameterized file.

How to use Parameterization

There are two parameterization features available in Web Testing:

1. By toggling the "Use New feature" option, you can create the datatable using our TDM service. Explore more about it in TDM documenation.

2. The existing feature allows you to parameterize the Steps by adding the data in the xlsx file and uploading the same data file before executing the Test Script. You can use the existing Parameterization feature by following the steps below:

Prerequisites

• Previously Created Project

• Previously Created Module

• Previously Created script

Note: This feature is also available within Test Lab and Sprints.

1. Navigate to previously created Test Script or Create new Test Steps by following the Step creation documentation.

2. After creating the steps you need to click on the "parameterize" button to make the column parameterized.

   

   Parameterization 1
3. Then you need to provide the Data Column name and save the script.

   

   Parameterization 2
4. Under the Parameter File tab, disable the "Use new feature" option.

   

   Parameterization 3
5. Follow the steps mentioned under the Parameter File tab.

   

   Parameterization 4
6. You can download the template file by clicking on the Download Template button.

7. Enter the required data in the data-table.

   Note: The Data Column name should be same as the Data Column added while creating the Test Steps.

   Test_Case : This field is mandatory and denotes the name of the test case execution for which the corresponding data will be referenced. Number of Test_Case rows denotes the number of execution which will be performed for the same test script, however each execution will have different data from corresponding Test_Case row. Example : since in the below image there are two rows for 'Test_Case', the test script will be executed two times, the first execution where Username step data value will be [e-mail] and the second execution where Username step data value will be [e-mail].

   

   Parameterization 5
8. Upload the updated data file by clicking on the Upload Template button.

   

   Parameterization 6
9. Once the file is successfully uploaded, you can execute the test.

   

   Parameterization 7
10. On the Run window disable the "Use new feature" option and click on Run Test button.

    

    Parameterization 8
11. The Test Script will be executed for the particular test cases defined in data table.

    

    Parameterization 9

Option to skip Parameterized Steps

Parameterization in script execution involves providing multiple sets of inputs. Typically, the test cases and corresponding data values are specified in a table, where each row represents a test case with data values in equivalent columns. However, this new feature allows us to skip the execution of a specific step associated with a data column by filling that column with a '~' operator in the parameterized excel file/table.

parameterization_10

The standard way of defining data in the sheet is.

parameterization_13

Test Result before negation/without ~ operator.

parameterization_14

To skip the step for one of the scenarios replace the amazon url with ~ operator

parameterization_11

Test Result after running with one scenario skipped.

parameterization_12