Of the unique needs of a requirements and test management system when working in the Defense industry, specifically when designing, building, and testing mission systems, is the ability to link individual test steps to the requirements.  This article provides you with a custom report to use to display such a traceability matrix.

Background

A customer asked us - I work in a project which has requirements traced directly to test steps and I would like the ability to report on execution progress at the test step level. I'd like to see which test steps are passed/failed, and if they are traced to a requirement.

Custom Report

If you use the following Entity SQL as a custom section:

select RS.REQUIREMENT_ID, RQ.NAME AS REQUIREMENT_NAME, TC.TEST_CASE_ID, TC.NAME AS TEST_CASE_NAME, RS.TEST_STEP_ID, TS.EXECUTION_STATUS_NAME
from SpiraTestEntities.R_RequirementTestSteps as RS
join SpiraTestEntities.R_Requirements as RQ on RS.REQUIREMENT_ID = RQ.REQUIREMENT_ID
join SpiraTestEntities.R_TestSteps as TS on RS.TEST_STEP_ID = TS.TEST_STEP_ID
join SpiraTestEntities.R_TestCases as TC on TC.TEST_CASE_ID = TS.TEST_CASE_ID
where RQ.PROJECT_ID = ${ProjectId}

It will display the following report for you:

Requirement IDRequirement NameTest Case IDTest Case NameTest Step IDExecution Status
      
Article Info
  • Last Updated: 10/18/2018
  • Article ID: KB397
  • Views: 132