Thread

Skip Navigation LinksForums > SpiraTeam Forums > Spira Custom Reports > Test execution status per...

Test execution status per Release with Actual result RSS Feed

Sunday, November 13, 2016
This report allows me to use Excel to draw a lot of information from the testing performed over multiple releases to see how we are tracking, find recurring issues, produce stats on the defects causing the largest impact to testing, etc.

Ver  5.0.0.8

Report sample:
Release Test Case ID Test Case Name Status Date Executed Actual Result
R7 - 20 Sept 3112 Upload documents - allowable formats Blocked 20/09/2016 Known environmental issue. Server being rebuilt
R8 - 3 Oct 3112 Upload documents - allowable formats Failed 4/10/2016 317
R9 - 12 Oct 3112 Upload documents - allowable formats Passed 12/10/2016  
R7 - 20 Sept 3115 Search functionality Passed 20/09/2016  
R8 - 3 Oct 3115 Search functionality Failed 4/10/2016 322
R9 - 12 Oct 3115 Search functionality Not Run
--  
R10 - 24 Oct 3115 Search functionality Passed 26/10/2016  
R11 - 7 Nov
3115 Search functionality Passed 9/11/2016  


Query:
select R.TEST_CASE_ID, R.TEST_CASE_NAME, R.EXECUTION_STATUS_NAME, R.ACTUAL_RESULT, R.END_DATE, L.RELEASE_NAME from SpiraTestEntities.R_TestRunSteps as R LEFT JOIN SpiraTestEntities.R_TestRuns AS L ON R.TEST_RUN_ID=L.TEST_RUN_ID AND 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">


<xsl:call-template name="format-date">
 <xsl:with-param name="datetime" select="CreationDate" />
</xsl:call-template>


    <table class="DataGrid">
 <tr>
<th>Release </th>
<th>Test Case ID</th>
 <th>Test Case Name</th>
 <th>Status</th>
 <th>Date Executed</th>
 <th>Actual Result</th>
 </tr>
       <xsl:for-each select="ROW">
         <tr>
 <td><xsl:value-of select="RELEASE_NAME"/></td>
 <td><xsl:value-of select="TEST_CASE_ID"/></td>
 <td><xsl:value-of select="TEST_CASE_NAME"/></td>
 <td><xsl:value-of select="EXECUTION_STATUS_NAME"/></td>

<td class="Date">
              <xsl:call-template name="format-date">
                <xsl:with-param name="datetime" select="END_DATE" />
              </xsl:call-template>
            </td>

 <td><xsl:value-of select="ACTUAL_RESULT" disable-output-escaping="yes"/></td>
         </tr>
       </xsl:for-each>
       </table>
    </xsl:template>

 <xsl:template name="format-date">
    <xsl:param name="datetime"/>
    <xsl:variable name="date" select="substring-before($datetime, 'T')" />
    <xsl:variable name="year" select="substring-before($date, '-')" />
    <xsl:variable name="month" select="substring-before(substring-after($date, '-'), '-')" />
    <xsl:variable name="day" select="substring-after(substring-after($date, '-'), '-')" />
    <xsl:variable name="time" select="substring-before(substring-after($datetime, 'T'), '.')" />
    <xsl:variable name="monthname">
      <xsl:choose>
        <xsl:when test="$month='01'">
          <xsl:value-of select="'Jan'"/>
        </xsl:when>
        <xsl:when test="$month='02'">
          <xsl:value-of select="'Feb'"/>
        </xsl:when>
        <xsl:when test="$month='03'">
          <xsl:value-of select="'Mar'"/>
        </xsl:when>
        <xsl:when test="$month='04'">
          <xsl:value-of select="'Apr'"/>
        </xsl:when>
        <xsl:when test="$month='05'">
          <xsl:value-of select="'May'"/>
        </xsl:when>
        <xsl:when test="$month='06'">
          <xsl:value-of select="'Jun'"/>
        </xsl:when>
        <xsl:when test="$month='07'">
          <xsl:value-of select="'Jul'"/>
        </xsl:when>
        <xsl:when test="$month='08'">
          <xsl:value-of select="'Aug'"/>
        </xsl:when>
        <xsl:when test="$month='09'">
          <xsl:value-of select="'Sep'"/>
        </xsl:when>
        <xsl:when test="$month='10'">
          <xsl:value-of select="'Oct'"/>
        </xsl:when>
        <xsl:when test="$month='11'">
          <xsl:value-of select="'Nov'"/>
        </xsl:when>
        <xsl:when test="$month='12'">
          <xsl:value-of select="'Dec'"/>
        </xsl:when>
        <xsl:otherwise>
          <xsl:value-of select="''" />
        </xsl:otherwise>
      </xsl:choose>
    </xsl:variable>
    <xsl:value-of select="concat($day, '-' ,$monthname, '-', $year)" />
  </xsl:template>

</xsl:stylesheet>
1 Replies
Adam SAdam S
re: Dave F on Sunday, November 13, 2016
Monday, November 14, 2016
Thanks Dave.
Tagged
Statistics
  • Started: 11/13/2016
  • Last Reply: 11/14/2016
  • Replies: 1
  • Views: 30
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.