Creating a Report of Documents in SpiraTeam

Custom Report

The good news is that the custom reporting features of SpiraTeam make this easy to achieve. You simply create a new report and add a custom section to the report:

The SQL you need to use for the custom section would be:

select
  D.PROJECT_ATTACHMENT_FOLDER_NAME as FOLDER_NAME,
  'DC' + cast (D.ATTACHMENT_ID as String) as DOCUMENT_ID,
  D.FILENAME as DOCUMENT_NAME,
  U.FIRST_NAME + ' ' + U.LAST_NAME as AUTHOR_NAME,
  D.CURRENT_VERSION
from SpiraTestEntities.R_Attachments as D
inner join SpiraTestEntities.R_Users as U on D.AUTHOR_ID = U.USER_ID
where D.PROJECT_ID = ${ProjectId}
order by D.FILENAME

and you can either have SpiraTeam generate the default template for this query, or use the following version (that has the column names prettified):

<?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">
    <table class="DataGrid"><tr><th>Folder Name</th><th>Document ID</th><th>Document Name</th><th>Author</th><th>Current Version</th></tr>
      <xsl:for-each select="ROW">
        <tr><td><xsl:value-of select="FOLDER_NAME"/></td><td><xsl:value-of select="DOCUMENT_ID"/></td><td><xsl:value-of select="DOCUMENT_NAME"/></td><td><xsl:value-of select="AUTHOR_NAME"/></td><td><xsl:value-of select="CURRENT_VERSION"/></td>
        </tr>
      </xsl:for-each>
        </table>
    </xsl:template>
</xsl:stylesheet>

The resulting output would be: