Report on the Document Type used by Test Case Automation Scripts

Thursday, August 9, 2018
Avatar

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?

1 Replies
Thursday, August 9, 2018
Avatar
re: inflectra.david Thursday, August 9, 2018

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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, August 9, 2018
  • Last Reply: Thursday, August 9, 2018
  • Replies: 1
  • Views: 8299