Custom report of test cases linked to incidents

Wednesday, October 11, 2017 3:52:30 AM

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 3:53:04 AM
Avatar
re: inflectra.adam on Wednesday, October 11, 2017 3:52:30 AM

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

 

Statistics
  • Started: Wednesday, October 11, 2017 3:52:30 AM
  • Last Reply: Wednesday, October 11, 2017 3:53:04 AM
  • Replies: 1
  • Views: 175