Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Custom report of test ste...
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:
Can you help me set up this custom report query?
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
And if you have any questions, please email or call us at +1 (202) 558-6885
