Test execution status per Release with Actual result

Monday, November 14, 2016
Avatar
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
Monday, November 14, 2016
Avatar
re: DaveFederal Monday, November 14, 2016
Thanks Dave.

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: Monday, November 14, 2016
  • Last Reply: Friday, November 3, 2023
  • Replies: 1
  • Views: 10268