Thread

Skip Navigation LinksForums > SpiraTeam Forums > Spira Custom Reports > All tests with test execu...

All tests with test execution Status and Actual results fields RSS Feed

Sunday, November 13, 2016
This report produces a single line for every test case executed with the Status(e.g. Passed, Failed) and the Actual result as typed in my the tester. This is useful if the testers put the defect ID# against failures and blockers.

ver
SpiraTeam v5.0.0.8

Report Sample
Test Case ID Test Case Name Status Date Executed Actual Result
1391 eReport - sanity checks Failed 13/09/2016 236
1391 eReport - sanity checks Failed 9/09/2016 259
1395 ePromotions - sanity checks Passed 20/09/2016  
1395 ePromotions - sanity checks Passed 13/09/2016  
1395 ePromotions - sanity checks Passed 9/09/2016  
1565 #18 - Member Export Publisher - 6 Edit a member by adding a comma Caution 19/09/2016 Exported with Comma and Quotes
1574 #18 - Member Export Publisher - 15 Edit member and with an invalid gender Caution 19/09/2016 The member has a gender set as A (truncated from ABCDEF) , this may cause issues when importing data
2601 VIP Room Access report Blocked 21/09/2016 289
2602 Player Status Report Blocked 21/09/2016 289
2603 Player Status Change History Passed 9/09/2016  


Query
select R.TEST_CASE_ID, R.TEST_CASE_NAME, R.EXECUTION_STATUS_NAME, R.ACTUAL_RESULT, R.END_DATE from SpiraTestEntities.R_TestRunSteps 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">


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


    <table class="DataGrid">
 <tr>
 <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="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: 72
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2017 | Licensed to Inflectra Corporation.