Inflectra Customer Forums: Custom report of test cases linked to incidents (Thread) A customer asked how to write a custom Entity SQL report that displayed: Incident ID Incident Status Name Test Case ID Test Case Name en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1751.aspxthreadId=1751David J (adam.sandman+support@inflectra.com)custom reports incidents test cases entity sqlCustom report of test cases linked to incidents A customer asked how to write a custom Entity SQL report that displayed: Incident ID Incident Status Name Test Case ID Test Case Name Wed, 11 Oct 2017 03:52:30 -04002017-10-11T03:53:04-04:00/Support/Forum/spirateam/reports/1751.aspxmessageId=3126David J (adam.sandman+support@inflectra.com) Heres the entity SQL you can use: select INC.INCIDENT_ID, INC.INCIDENT_STATUS_NAME, TC.TEST_CASE_ Heres 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 Wed, 11 Oct 2017 03:53:04 -04002017-10-11T03:53:04-04:00/Support/Forum/spirateam/reports/1751.aspx#reply3126