Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Report on the Document Ty...
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 don’t 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?
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 don’t 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?
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
And if you have any questions, please email or call us at +1 (202) 558-6885