Generating reports across multiple projects?

Thursday, September 11, 2014 9:57:27 PM
We're trying to gather data across projects, but SpiraTeam does not provide portfolio functionality. Is there a way to run a cross-project SQL query on an Inflectra-hosted implementation?
1 Replies
Friday, September 12, 2014 6:04:18 PM
Avatar
re: pelikan on Thursday, September 11, 2014 9:57:27 PM

Hi Steve

Yes you can do this as long as you have system administration permissions (because SQL level access will violate the role based security in the system naturally). So to access it, please go to:

Administration > System > Edit Reports.

Create a new custom report. Add a custom section to the report.

Then from the dropdown list, choose the base query (e.g. requirements) and now you have a SQL entry window and a preview option. Once you are happy with the data, you can use the 'Create Template' to build a displayable XML template for the report.

Regards

Adam

Statistics
  • Started: Thursday, September 11, 2014 9:57:27 PM
  • Last Reply: Friday, September 12, 2014 6:04:18 PM
  • Replies: 1
  • Views: 1017