Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Custom report of test cas...
A customer asked how to write a custom Entity SQL report that displayed:
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