Inflectra Customer Forums: Report Displaying Projects, Project Groups and Releases (Thread) 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. en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1725.aspxthreadId=1725David J (support1@inflectra.com)custom reports esql project groups projects releasesReport Displaying Projects, Project Groups and Releases 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. Fri, 21 Jul 2017 15:28:34 -04002017-07-21T15:29:55-04:00/Support/Forum/spirateam/reports/1725.aspxmessageId=3068David J (support1@inflectra.com) Heres the Entity SQL you need to use to get that data: select P.PROJECT_ID, P.NAME, P.PROJECT_GRO Heres 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 heres the XSLT template to put that into a nice grid: PROJECT_ID NAME PROJECT_GROUP_ID PROJECT_GROUP_NAME RELEASE_ID RELEASE_NAME RELEASE_STATUS_NAME Fri, 21 Jul 2017 15:29:55 -04002017-07-21T15:29:55-04:00/Support/Forum/spirateam/reports/1725.aspx#reply3068