Created By  inflectra.adam Monday, October 21, 2013
Several users have asked --  if it is possible to extract all incidents logged in a SpiraTest sever no matter what the project is. Using the built-in Incident reports or Excel Add-In, you have to extract incidents for each project and then move into one spreadsheet however they wanted to know if it was possible to do this as one extract from within the tool.

Since version v4.0 this is possible. To achieve this, you will need to create a Custom Report.


  1. Go to Administration > Edit Reports and create a custom report.
  2. Add a custom section to this report
  3. Make sure Excel is listed as one of the output formats supported
  4. In the custom section add the Incidents query.
  5. Remove the where clause (the one that limits it by project) so that it looks like:

    select value R from SpiraTestEntities.R_Incidents as R where R.is_deleted = false

  6. Save the report.

Now go to the main Reports section and run this report in MS-Excel format.


Article Info
  • Last Updated: 10/21/2013
  • Article ID: KB60
  • Views: 3610