All tests with test execution Status and Actual results fields

Sunday, November 13, 2016 11:00:19 PM
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
Monday, November 14, 2016 3:06:52 PM
Avatar
re: DaveFederal on Sunday, November 13, 2016 11:00:19 PM
Thanks Dave.
Statistics
  • Started: Sunday, November 13, 2016 11:00:19 PM
  • Last Reply: Monday, November 14, 2016 3:06:52 PM
  • Replies: 1
  • Views: 154