<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Very simple traceability matrix - Requirement to Test case report (Thread)</title><description>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 &#xD;
	                v 5.0.0 . 8    Report sample  &#xD;
&#xD;
  &#xD;
&#xD;
  &#xD;
&#xD;
   Requirement / Test Case Traceability Report &#xD;
&#xD;
     &#xD;
&#xD;
  &#xD;
   REQUIREMENT_ID &#xD;
   REQUIREMENT_NAME &#xD;
   TEST_CASE_ID &#xD;
   TEST_CASE_NAME &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2600 &#xD;
   Reports can be&#xD;
  accessed remotely and are filterable &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2601 &#xD;
   VIP Room Access&#xD;
  report &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2602 &#xD;
   Player Status Report &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2603 &#xD;
   Player Status Change&#xD;
  History &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2604 &#xD;
   RG Incidents by&#xD;
  member &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2605 &#xD;
   WPH RG Manager/Staff,&#xD;
  member home venue is WPH &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2606 &#xD;
   WPH RG Manager/Staff,&#xD;
  member home venue is CCT &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2607 &#xD;
   CCT RG Manager/Staff,&#xD;
  member home venue is CCT &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2608 &#xD;
   CCT RG Manager/Staff,&#xD;
  member home venue is WPH &#xD;
&#xD;
 &#xD;
&#xD;
 &#xD;
&#xD;
 &#xD;
&#xD;
    Query  select R.REQUIREMENT_ID, &#xD;
R.REQUIREMENT_NAME, R.TEST_CASE_ID, R.TEST_CASE_NAME from &#xD;
SpiraTestEntities. R_RequirementTestCases as R where R.PROJECT_ID = &#xD;
${ProjectId}    Template                      REQUIREMENT_ID     REQUIREMENT_NAME     TEST_CASE_ID     TEST_CASE_NAME                                                                                 &#xD;
&#xD;
</description><language>en-US</language><copyright>(C) Copyright 2006-2026 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><a10:id>http://www.inflectra.com/kronodesk/forums/threads</a10:id><ttl>120</ttl><link>/Support/Forum/spirateam/reports/1567.aspx</link><item><guid isPermaLink="false">threadId=1567</guid><author>Dave F (david.furlani@federalgroup.com.au)</author><category domain="http://www.inflectra.com/kronodesk/thread/tag">reporting</category><title>Very simple traceability matrix - Requirement to Test case report</title><description>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 &#xD;
	                v 5.0.0 . 8    Report sample  &#xD;
&#xD;
  &#xD;
&#xD;
  &#xD;
&#xD;
   Requirement / Test Case Traceability Report &#xD;
&#xD;
     &#xD;
&#xD;
  &#xD;
   REQUIREMENT_ID &#xD;
   REQUIREMENT_NAME &#xD;
   TEST_CASE_ID &#xD;
   TEST_CASE_NAME &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2600 &#xD;
   Reports can be&#xD;
  accessed remotely and are filterable &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2601 &#xD;
   VIP Room Access&#xD;
  report &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2602 &#xD;
   Player Status Report &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2603 &#xD;
   Player Status Change&#xD;
  History &#xD;
&#xD;
  &#xD;
   104 &#xD;
   3.14 RG Reporting &#xD;
   2604 &#xD;
   RG Incidents by&#xD;
  member &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2605 &#xD;
   WPH RG Manager/Staff,&#xD;
  member home venue is WPH &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2606 &#xD;
   WPH RG Manager/Staff,&#xD;
  member home venue is CCT &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2607 &#xD;
   CCT RG Manager/Staff,&#xD;
  member home venue is CCT &#xD;
&#xD;
  &#xD;
   103 &#xD;
   3.13 RG Management&#xD;
  User Matrix &#xD;
   2608 &#xD;
   CCT RG Manager/Staff,&#xD;
  member home venue is WPH &#xD;
&#xD;
 &#xD;
&#xD;
 &#xD;
&#xD;
 &#xD;
&#xD;
    Query  select R.REQUIREMENT_ID, &#xD;
R.REQUIREMENT_NAME, R.TEST_CASE_ID, R.TEST_CASE_NAME from &#xD;
SpiraTestEntities. R_RequirementTestCases as R where R.PROJECT_ID = &#xD;
${ProjectId}    Template                      REQUIREMENT_ID     REQUIREMENT_NAME     TEST_CASE_ID     TEST_CASE_NAME                                                                                 &#xD;
&#xD;
</description><pubDate>Sun, 13 Nov 2016 22:45:58 -0500</pubDate><a10:updated>2018-08-16T06:58:32-04:00</a10:updated><link>/Support/Forum/spirateam/reports/1567.aspx</link></item><item><guid isPermaLink="false">messageId=2813</guid><author>David J (adam.sandman+support@inflectra.com)</author><title>&#xD;
Thanks Dave! &#xD;
&#xD;
</title><description>&#xD;
Thanks Dave! &#xD;
&#xD;
</description><pubDate>Mon, 14 Nov 2016 15:06:22 -0500</pubDate><a10:updated>2016-11-14T15:06:22-05:00</a10:updated><link>/Support/Forum/spirateam/reports/1567.aspx#reply2813</link></item><item><guid isPermaLink="false">messageId=3372</guid><author>Tung Nguyen (tran.nguyen@transport.nsw.gov.au)</author><title> Hi, how can I get the Requirement Description instead of Name? And how can I append the test result</title><description> Hi, how can I get the Requirement Description instead of Name? And how can I append the test results for the test run?  Thank you </description><pubDate>Thu, 16 Aug 2018 06:58:32 -0400</pubDate><a10:updated>2018-08-16T06:58:32-04:00</a10:updated><link>/Support/Forum/spirateam/reports/1567.aspx#reply3372</link></item></channel></rss>