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