Search ALM XDS for Test Hits and Gaps

This workflow searches an ALM database to find tests and design steps whose names or descriptions match a supplied set of tokens. The results are used to generate an Excel report.

Before You Begin

The workflow requires a Data Store named ALM to be created in the workspace where the workflow is to be run. The ALM Data Store should contain the following tables:

  • TESTS: This table stores test details and should be populated from the ALM database’s td.BL_TEST table.

  • DESIGN STEPS: This table stores test details and should be populated from the ALM database’s td.BL_DESSTEPS table.

The ALM Data Store may be populated by carrying out the following steps.

  1. Create two SQL Server External Data Sources in LiveCompare.

    1. The ALM_Tests External Data Source should access the ALM database’s td.BL_TEST table.

      1. The ALM_DesignSteps External Data Source should access the ALM database’s td.BL_DESSTEPS table.

  2. In a workflow, use two Read External Data Source actions to read each External Data Source. The workflow should have two Result Table datasets, named Tests and Design Steps.

  3. Use a Write Data Store action to write the Tests table to a table named TESTS in a Data Store named ALM. The Write Data Store action’s Overwrite property should be set to True.

  4. Use a second Write Data Store action to write the Design Steps table to a table named DESIGNSTEPS in the ALM Data Store. The Write Data Store action’s Overwrite property should be set to True.

Preparing the Workflow

To prepare the Search ALM XDS for Test Hits and Gaps workflow, drag its workflow template from the Templates folder into a workspace that contains the ALM Data Store, then modify the workflow as follows:

To specify the tokens for which to search.

  1. Edit the Raw Tokens Table dataset and click ‘Clear’ to remove the original table entries. Enter a new set of tokens or paste them into the table from an Excel spreadsheet.

  2. Alternatively, enter a set of tokens into the Test Raw Tokens Table dataset, and modify the first Convert Data action’s InTable property so that it links to Test Raw Tokens rather than to Raw Tokens.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the Search ALM XDS for Test Hits and Gaps workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the context menu or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Report URL dataset and choose ‘View Details’ from the context menu to display the generated report.

Workflow Results

The Search ALM XDS for Test Hits and Gaps workflow generates an Excel report which lists the number of hits for each token A hit occurs if the token matches against either a test name, test description, design step name or design step description in the data retrieved from the ALM Data Source. Note that tokens for which no matches are found have a TEST_HITS value of 1.