Test execution status per Release with Actual result

Monday, November 14, 2016 12:12:53 AM

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 3:09:06 PM

inflectra.adam

re: DaveFederal on Monday, November 14, 2016 12:12:53 AM

Thanks Dave.

Statistics

Started: Monday, November 14, 2016 12:12:53 AM
Last Reply: Monday, November 14, 2016 3:09:06 PM
Replies: 1
Views: 1450

Test execution status per Release with Actual result

Edit Thread

Edit Message

Search Results