Generating reports across multiple projects?

Thursday, September 11, 2014
Avatar
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
Avatar
re: pelikan Thursday, September 11, 2014

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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, September 11, 2014
  • Last Reply: Friday, September 12, 2014
  • Replies: 1
  • Views: 9765