Knowledge Base Article

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article Exporting all incidents out of the system into Excel

by Adam S on 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: 1942
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.