Skip to content

Executing tests with Data Filter overrides in the Test Scheduler

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 2 


1. Executing tests with Data Filter overrides in the Test Scheduler
We will use 2 Data Filters on the same Data File and execute the test simultaneously:
  • The First Data Filter to override is Filter for State_Code NJ.
  • The Second Filter to override is Filter for State_Code PA.
We have already created the Data Filters previously, so we will focus on the format of the data inputs to help us with overriding these Data Filter values. To simply our understanding of this format, it has 3 sets of information:
  • The first set of information is the name of the current Data File (in the Bind Summary Screen) along with its status
  • The second set of information is the name of the Data file to be replaced with.
  • The third set of information is the name of the current Data Filter (in the Bind Summary Screen) and the name of the second filter to be replaced with.
       [ 
       {   
         "currentDataFileName":"YOUR_CURRENT_DATA_FILE_NAME",                                                       "currentDataFileStatus":"YOUR_CURRENT_DATA_FILE_STATUS",                                                   "replacementDataFileName":" YOUR_REPLACEMENT_DATA_FILE_NAME",                                     "replacementDataFileStatus":"YOUR_REPLACEMENT_DATA_FILE_STATUS",                                 "currentDataFilterName":"YOUR_CURRENT_DATA_FILTER_NAME",                                                 "replacementDataFilterName":"YOUR_REPLACEMENT_DATA_FILTER_NAME"        
          }       
          ]
     
        
2. Practice:
Overriding with Data Filter - NJ
  1. Click Menu then click Data Files' to edit the driver data File "Business Test Run Details"
  2. Clone the Last row to create a new row and save it. 
  3. Update the following:
  4. Execution Indicator (Type= Yes)
  5. Run definition Details:
  6. Testing Context key of 'RD - Verify HICC calculations (Data Filters on Data Files)' (pick Testing Context key with Worksoft SaaS - High Volume Cloud)
  7. Name_Mnemonics: Data-driven by Data Files with Static Data Filter
  8. Status: Update the Status
  9. User_notes_Override: Data-Driven by Data File with Static Data Filter - NJ
  10. Update the Data Filter Override:                                                                                                    

 [{    "currentDataFileName": "HICC - 1 Zip code or state in 3 States",    "currentDataFileStatus": "WIP",
    "replacementDataFileName": "HICC - Multistate Inputs & Outputs",
    "replacementDataFileStatus": "WIP",
    "currentDataFilterName": "Filter on State_Code NJ",
    "replacementDataFilterName": "Filter on State_Code NY"
}]
  1. To check the Current Data File Name and Status: Go to Run Definition Home page-> Select 'RD - Verify HICC calculations (Data Filters on Data Files)' and click on the Data Files column -> Copy the File Name and status separately and paste into relevant rows.
  2. To check the Replacement Data File Name and Status: Go to More-> Copy the File Name and Status of the Data File that you want to replace with.
  3. To check with Current Filter Name and Status: Go to Run Definition Home page-> Select 'RD - Verify HICC calculations (Data Filters on Data Files)' and click on Link Icon in action bar to navigate to Binding screen -> click on Filter Icon to check the Current Filter name.
  4. To check With Replacement Data Filter name: Go to Run Definition Home page-> For 'RD - Verify HICC calculations (Data Filters on Data Files)' Click on Link Icon in the action bar to navigate to Binding screen -> click on Filter Icon to check the Replacement Filter name.
        Overriding with Data Filter - PA    
  1. Go to 'More-> Data Files' to edit the driver data File "Business Test Run Details"
  2. Clone the previous row to create a new row and save it. (If you are unable to clone the row, that means one of the attribute and data is encrypted, decrypt it by clicking on the lock icon)
  3. Update the following:
  4. Execution Indicator ( Type= ** Yes** )
  5. Run Definition Details:
  6. Testing Context key of 'RD - Verify HICC calculations (Data Filters on Data Files)' (pick Testing Context key with Worksoft SaaS - High Volume Cloud)
  7. Name_Mnemonics: Data-driven by Data Files with Static Data Filter
  8. Status: Update the Status
  9. User_notes_Override: Data-Driven by Data File with Static Data Filter - PA
  10. Update the Data File Overrides:                                                                                                 

[{
    "currentDataFileName": "HICC - 1 Zip code or state in 3 States",
    "currentDataFileStatus": "WIP",
    "replacementDataFileName": "HICC - Multistate Inputs & Outputs",
    "replacementDataFileStatus": "WIP",
    "currentDataFilterName": "Filter on State_Code NJ",
    "replacementDataFilterName": "Filter on State_Code PA"
}]
  1. Change the Execution Indicator details of all other rows to 'No':
  2. Click on save and exit.  
3. Practice: Updating the Test Cycle Inputs File and Trigger Test Scheduler
  1. Click vertical ellipsis to edit Test Cycle Inputs.
  2. Edit the Test_Cycle_Info
  3. Update the testcycleidentifier as Test Cycle 4
  4. Update the plannedWindowsStartTime:
  5. Update the plannedWindowEndTime:
  6. Click Save and click Save & Exit.
  7. Click Menu and Click Test Cycle
  8. Click ExecuteTest Scheduler.
  9. Select on dropdown to select Test Cycle Inputs
  10. Click Schedule
Please note: 
  • The Overridden values will not replace the actual values in the Data File or Data Filter



Feedback and Knowledge Base