Very simple traceability matrix - Requirement to Test case report

Sunday, November 13, 2016 10:45:58 PM
The attached it useful for reporting on test case coverage.  I wanted this to be simple and clean.  I hope some of you find this useful.

Spira ver - SpiraTeam v5.0.0.8

Report sample
Requirement / Test Case Traceability Report    
REQUIREMENT_ID REQUIREMENT_NAME TEST_CASE_ID TEST_CASE_NAME
104 3.14 RG Reporting 2600 Reports can be accessed remotely and are filterable
104 3.14 RG Reporting 2601 VIP Room Access report
104 3.14 RG Reporting 2602 Player Status Report
104 3.14 RG Reporting 2603 Player Status Change History
104 3.14 RG Reporting 2604 RG Incidents by member
103 3.13 RG Management User Matrix 2605 WPH RG Manager/Staff, member home venue is WPH
103 3.13 RG Management User Matrix 2606 WPH RG Manager/Staff, member home venue is CCT
103 3.13 RG Management User Matrix 2607 CCT RG Manager/Staff, member home venue is CCT
103 3.13 RG Management User Matrix 2608 CCT RG Manager/Staff, member home venue is WPH

Query
select R.REQUIREMENT_ID, R.REQUIREMENT_NAME, R.TEST_CASE_ID, R.TEST_CASE_NAME from SpiraTestEntities. R_RequirementTestCases as R where R.PROJECT_ID = ${ProjectId}

Template
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  <xsl:template match="/RESULTS">
    <table class="DataGrid">
 <tr>
  <th>REQUIREMENT_ID</th>
  <th>REQUIREMENT_NAME</th>
  <th>TEST_CASE_ID</th>
  <th>TEST_CASE_NAME</th></tr>
      <xsl:for-each select="ROW">
         <tr>
  <td><xsl:value-of select="REQUIREMENT_ID"/></td>
  <td><xsl:value-of select="REQUIREMENT_NAME"/></td>
  <td><xsl:value-of select="TEST_CASE_ID"/></td>
  <td><xsl:value-of select="TEST_CASE_NAME"/></td>
         </tr>
      </xsl:for-each>
      </table>
    </xsl:template>
</xsl:stylesheet>
1 Replies
Monday, November 14, 2016 3:06:22 PM
Avatar
re: DaveFederal on Sunday, November 13, 2016 10:45:58 PM
Thanks Dave!
Statistics
  • Started: Sunday, November 13, 2016 10:45:58 PM
  • Last Reply: Monday, November 14, 2016 3:06:22 PM
  • Replies: 1
  • Views: 223