A customer asked: I need to create a custom graph that shows the amount of test cases per document type. However when I look at the columns that are returned when I query the SpiraTestEntities.R_TestCases table (from within the Edit Graphs screen), I dont see any columns that represents the Document Type field. Which table should I query in order to find the Document Type value for a test case? 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/1895.aspxthreadId=1895David J (adam.sandman+support@inflectra.com)reports custom reporting spirateam test case automation documents attachments A customer asked: I need to create a custom graph that shows the amount of test cases per document type. However when I look at the columns that are returned when I query the SpiraTestEntities.R_TestCases table (from within the Edit Graphs screen), I dont see any columns that represents the Document Type field. Which table should I query in order to find the Document Type value for a test case? Thu, 09 Aug 2018 01:46:08 -04002018-08-09T01:46:28-04:00/Support/Forum/spirateam/reports/1895.aspxmessageId=3365David J (adam.sandman+support@inflectra.com) The AUTOMATION_ATTACHMENT_ID is a foreign key into the main Attachments record, something like this: select TC.TEST_CASE_ID, TC.AUTOMATION_ATTACHMENT_ID, AT.PROJECT_ATTACHMENT_TYPE_NAME from SpiraTestEntities.R_TestCases as TC join SpiraTestEntities.R_Attachments as AT on TC.AUTOMATION_ATTACHMENT_ID = AT.ATTACHMENT_ID where TC.PROJECT_ID = ${ProjectId} Regards Adam Thu, 09 Aug 2018 01:46:28 -04002018-08-09T01:46:28-04:00/Support/Forum/spirateam/reports/1895.aspx#reply3365