Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Report Displaying Project...
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 Group2. Project Name3. Release name4. Release workflow status.
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.
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>
And if you have any questions, please email or call us at +1 (202) 558-6885