Report Displaying Projects, Project Groups and Releases

Friday, July 21, 2017
Avatar

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
Avatar
re: inflectra.david Friday, July 21, 2017

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>

 

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Friday, July 21, 2017
  • Last Reply: Friday, July 21, 2017
  • Replies: 1
  • Views: 8669