Custom report of test cases linked to incidents

Wednesday, October 11, 2017
Avatar

A customer asked how to write a custom Entity SQL report that displayed:

  • Incident ID
  • Incident Status Name
  • Test Case ID
  • Test Case Name
1 Replies
Wednesday, October 11, 2017
Avatar
re: inflectra.david Wednesday, October 11, 2017

Here's the entity SQL you can use:

select INC.INCIDENT_ID, INC.INCIDENT_STATUS_NAME, TC.TEST_CASE_ID, TC.NAME as TEST_CASE_NAME
from SpiraTestEntities.R_Incidents as INC
join SpiraTestEntities.R_TestCaseIncidents as TCI on INC.INCIDENT_ID = TCI.INCIDENT_ID
join SpiraTestEntities.R_TestCases as TC on TC.TEST_CASE_ID = TCI.TEST_CASE_ID

 

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Wednesday, October 11, 2017
  • Last Reply: Wednesday, October 11, 2017
  • Replies: 1
  • Views: 6857