Report Displaying Projects, Project Groups and Releases

Friday, July 21, 2017 3:28:34 PM

We had a request from a customer looking for a custom report with the following information:

We need a  report  or exported data dump from the system having following  data.  it seems there is no such default report  for the same.

Please share the  detail where these data points stored in the DB. that will help us to write a query to export the dump.

1. Project Group

2. Project Name

3. Release name

4. Release workflow status.

1 Replies
Friday, July 21, 2017 3:29:55 PM
Avatar
re: inflectra.adam on Friday, July 21, 2017 3:28:34 PM

Here's the Entity SQL you need to use to get that data:

select P.PROJECT_ID, P.NAME, P.PROJECT_GROUP_ID, P.PROJECT_GROUP_NAME, R.RELEASE_ID, R.NAME as RELEASE_NAME, R.RELEASE_STATUS_NAME from SpiraTestEntities.R_Projects as P
join SpiraTestEntities.R_Releases as R on R.PROJECT_ID = P.PROJECT_ID

and here's the XSLT template to put that into a nice grid:

<?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>PROJECT_ID</th><th>NAME</th><th>PROJECT_GROUP_ID</th><th>PROJECT_GROUP_NAME</th><th>RELEASE_ID</th><th>RELEASE_NAME</th><th>RELEASE_STATUS_NAME</th></tr>
      <xsl:for-each select="ROW">
        <tr><td><xsl:value-of select="PROJECT_ID"/></td><td><xsl:value-of select="NAME"/></td><td><xsl:value-of select="PROJECT_GROUP_ID"/></td><td><xsl:value-of select="PROJECT_GROUP_NAME"/></td><td><xsl:value-of select="RELEASE_ID"/></td><td><xsl:value-of select="RELEASE_NAME"/></td><td><xsl:value-of select="RELEASE_STATUS_NAME"/></td>
        </tr>
      </xsl:for-each>
        </table>
    </xsl:template>
</xsl:stylesheet>

 

Statistics
  • Started: Friday, July 21, 2017 3:28:34 PM
  • Last Reply: Friday, July 21, 2017 3:29:55 PM
  • Replies: 1
  • Views: 391