Inflectra Customer Forums: Exporting Incident Change History to Excel (Thread) We had the following request from a customer: Id like to export the Incident Change History to Excel for reporting purposes. In particular Im interested in seeing the Status Changes of all incidents in my project. How can I implement such a report? en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1737.aspxthreadId=1737David J (support1@inflectra.com)custom reports custom reporting incident historyExporting Incident Change History to Excel We had the following request from a customer: Id like to export the Incident Change History to Excel for reporting purposes. In particular Im interested in seeing the Status Changes of all incidents in my project. How can I implement such a report? Sat, 26 Aug 2017 07:43:52 -04002017-08-26T08:33:03-04:00/Support/Forum/spirateam/reports/1737.aspxmessageId=3099David J (support1@inflectra.com) The following Entity SQL (ESQL) should be used to generate the report: select C.CHANGESET_ID as C The following Entity SQL (ESQL) should be used to generate the report: select C.CHANGESET_ID as ChangeSetId, C.CHANGE_DATE as ChangeDate, C.ARTIFACT_ID as IncidentId, C.ARTIFACT_DESC as IncidentName, D.FIELD_CAPTION as FieldName, D.OLD_VALUE as OldValue, D.NEW_VALUE as NewValue from SpiraTestEntities.R_HistoryChangeSets as C join SpiraTestEntities.R_HistoryDetails as D on C.CHANGESET_ID = D.CHANGESET_ID where C.PROJECT_ID = ${ProjectId} and C.ARTIFACT_TYPE_ID = 3 The automated XSLT template that Spira will generate will look like: ChangeSetId ChangeDate IncidentId IncidentName FieldName OldValue NewValue And the final output looks like: ChangeSetId ChangeDate IncidentId IncidentName FieldName OldValue NewValue 5 2005-03-04T14:17:00 6 The book listing screen doesnt sort Status New Open 6 2005-03-04T16:54:00 7 Cannot add a new book to the system Type Incident Bug 7 2005-03-05T10:32:00 6 The book listing screen doesnt sort Type Incident Bug 8 2005-03-05T10:35:00 7 Cannot add a new book to the system Status New Open 13 2006-05-02T16:34:00 7 Cannot add a new book to the system Status Open Assigned Sat, 26 Aug 2017 08:33:02 -04002017-08-26T08:33:02-04:00/Support/Forum/spirateam/reports/1737.aspx#reply3099