Thread

Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > User wants us to create a...

User wants us to create a custom report from Spira using Spira db tables - where I get a list of Spira db tables? RSS Feed

Monday, August 18, 2014
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

2 Replies
Jim R.Jim R.
re: Ruth L Collier on Monday, August 18, 2014
Tuesday, August 19, 2014
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:
  1. Click on Administration > System > Edit Reports
  2. Choose the option to create a new report
  3. Choose to add a new 'Custom Section' to the report
  4. 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)
  5. This will generate a SQL query that looks like select value R from SpiraTestEntities.R_Incident where PROJECT_ID = ${ProjectId}
  6. Then click on 'Generate Default Template'
  7. This will populate the XSLT for generating a simple table containing the data in this query
  8. Save the report

You can then use more advanced SQL to join tables, do aggregations, etc.

Regards

Jim
Ruth L CollierRuth L Collier
re: Jim R. on Tuesday, August 19, 2014
Tuesday, August 26, 2014
Thanks Jim.
Tagged
Statistics
  • Started: 8/18/2014
  • Last Reply: 8/26/2014
  • Replies: 2
  • Views: 535
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.