Inflectra Customer Forums: User wants us to create a custom report from Spira using Spira db tables - where I get a list of Spira db tables? (Thread)

Inflectra Customer Forums: User wants us to create a custom report from Spira using Spira db tables - where I get a list of Spira db tables? (Thread) Hello - 'would it be possible to have read permissions granted on the SPIRA database tables for the user Jasper? E.g. tst_incident, tst_project, etc'. I got the above request from a user. He wants us to create a report for a named user (Jasper, as in JasperSoft) to run off queries from Spira db tables tst_incident, tst_project... *Where can I find a list of SpiraTeam db tables? * How do I create a custom report using SQL for basic queries in Spira, i.e. not the embedded reports? Many thanks, Ruth en-US(C) Copyright 2006-2026 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/issues-questions/973.aspxthreadId=973Ruth L Collier (ruthlavinia@me.com)reportingUser wants us to create a custom report from Spira using Spira db tables - where I get a list of Spira db tables? Hello - 'would it be possible to have read permissions granted on the SPIRA database tables for the user Jasper? E.g. tst_incident, tst_project, etc'. I got the above request from a user. He wants us to create a report for a named user (Jasper, as in JasperSoft) to run off queries from Spira db tables tst_incident, tst_project... *Where can I find a list of SpiraTeam db tables? * How do I create a custom report using SQL for basic queries in Spira, i.e. not the embedded reports? Many thanks, Ruth Mon, 18 Aug 2014 15:13:33 -04002014-08-26T11:15:24-04:00/Support/Forum/spirateam/issues-questions/973.aspxmessageId=1774Jim R (donotreply5@kronodesk.net) Hi Ruth Assuming that you're running v4.0 or later of SpiraTeam, you don't need to do this. You Hi Ruth Assuming that you're running v4.0 or later of SpiraTeam, you don't need to do this. You can create custom reports directly against the system using the web-based reporting that comes with the system: Click on Administration > System > Edit Reports Choose the option to create a new report Choose to add a new 'Custom Section' to the report For this new custom section, choose the appropriate reportable entity (e.g. Incidents corresponds to the TST_INCIDENT table, plus all its joined entities in an easy to report-on view) This will generate a SQL query that looks like select value R from SpiraTestEntities.R_Incident where PROJECT_ID = ${ProjectId} Then click on 'Generate Default Template' This will populate the XSLT for generating a simple table containing the data in this query Save the report You can then use more advanced SQL to join tables, do aggregations, etc. Regards Jim Tue, 19 Aug 2014 15:12:43 -04002014-08-19T15:12:43-04:00/Support/Forum/spirateam/issues-questions/973.aspx#reply1774messageId=1796Ruth L Collier (ruthlavinia@me.com) Thanks Jim. Thanks Jim.Tue, 26 Aug 2014 11:15:24 -04002014-08-26T11:15:24-04:00/Support/Forum/spirateam/issues-questions/973.aspx#reply1796