Very simple traceability matrix - Requirement to Test case report

Sunday, November 13, 2016

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>

2 Replies

Monday, November 14, 2016