Skip to content

Executing tests using Data Filters on Data Files

This article is a part of the Self-paced Learning Series for the Course: First-Hand Experience of Worksoft SaaS.

Please refer to the link for more details on the Course.
 
 Mapping the Worksoft SaaS feature to the Course Context :: Lesson 8:: Topic 1


1. Executing tests using Data Filters on Data Files
We will use a different Data File that contains test data of all the 3 Test Cases (States - NJ, NY, PA) and apply filters on a particular State to execute the test only for that State. 

We will also create the Data Filters for 2 of these States and use them for 2 individual executions.
        
       
2. Practice
First, create a Data Filter for the State NJ:
  1. Click Menu and Click Data Filters
  2. Click Create on top right corner
  3. Select HICC - Input and Expected Outputs - WIP in Data Definition dropdown.
  4. In the name field update name as  'Filter on State_Code NJ' (Mandatory)
  5. Select the attribute as State-Code and operator as (=)
  6. In the value Field, Type NJ for New Jersey.
  7. To check if the filter is working, select the file in Data File dropdown and click on (Show Filtered Data). The filtered results should display as expected.
  8. Click on Save and Exit. 
Create another Data Filter for the State NY:
  1. Click on Clone Icon to Create another Filter
  2. Add description 'Filter on State_Code NY' (Mandatory)
  3. In the value Field, Type NY (for New York).
  4. To check if the filter is working, select the file in Data File dropdown and click on (Show Filtered Data). The filtered results should display as expected.
  5. Click on Save and Exit.
Create another Data Filter for the State PA:
  1. Click on Clone Icon to Create another Filter
  2. Add description 'Filter on State_Code PA' (Mandatory)
  3. In the value Field, Type NY (for New York).
  4. To check if the filter is working, select the file in data File dropdown and click on (Show Filtered Data). The filtered results should display as expected.
  5. Click on Save and Exit.
Clone RD - Verify HICC calculations (Data-driven by Data File) and make the following changes:
  1. Update the RD name to 'Verify HICC calculations (Data Filters on Data Files)' (We will use the same Scenario, no changes needed)
  2. Click on Continue. In Configure Bindings field, Select the Data File "Data File with 'HICC - 1 Zipcode/state in 3 States" in the data binding screen, Click on apply Filter right next to bind data file. Select the Filter for New Jersey and click on Apply.
  3. Click on the proceed to testing Context Screen
  4. Execute the test and expect to see the test executed only for NJ

Now, change the filter from New Jersey to New York and re-execute the tests, to do that, follow these steps:
  1. Click on File Binding Icon on Verify HICC calculations (Data Filters on Data Files)
  2. Click on Change Filter right next to bind data file
  3. Select the Filter for New York and click on Apply.
  4. Click on the proceed to testing Context Screen and Select Testing Context with Functional High Volume Cloud
  5. Execute the test and expect to see the test executed only for NY
  
Please Note:
  • We also recommend that you create another Data Filter for the State PA which will be used in the next topic  
     


Feedback and Knowledge Base