Custom report of test steps

Thursday, October 19, 2017 2:05:40 PM

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, if they are traced to a requirement and if they are traced to an Incident.

This is what I would like the ability to view:

Test Set IDTest Set NameTest Case IDTest Case NameTest Step IDRun StatusLinked Requirement IDLinked Incident ID
        

 

Can you help me set up this custom report query?

1 Replies
Friday, October 27, 2017 1:24:31 PM
Avatar
re: bthomas3 on Thursday, October 19, 2017 2:05:40 PM

Hi Brandon,

I have part of the query for you. It shows the requirements, test cases, test steps linked:

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}

Regards

Jim

Statistics
  • Started: Thursday, October 19, 2017 2:05:40 PM
  • Last Reply: Friday, October 27, 2017 1:24:31 PM
  • Replies: 1
  • Views: 153