All My report writing skills within SpiraTest are sadly not the strongest. If I had DB access I could probably produce the report i require. For a project i am currently on it would be fantastic to generate a custom report which outputs all the incidents within a project, the name and the description and the current status and how many times it has changed status and output the historic status names I know we can see this within each incident. A report to show it would be great en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1364.aspxthreadId=1364Howard Clark (itqatestmanagement@Impellam.com)custom reports writing incident status workflow All My report writing skills within SpiraTest are sadly not the strongest. If I had DB access I could probably produce the report i require. For a project i am currently on it would be fantastic to generate a custom report which outputs all the incidents within a project, the name and the description and the current status and how many times it has changed status and output the historic status names I know we can see this within each incident. A report to show it would be great Mon, 15 Feb 2016 16:26:33 -05002016-02-23T18:19:42-05:00/Support/Forum/spiratest/issues-questions/1364.aspxmessageId=2500Inflectra Sarah (donotreply6@kronodesk.net) Hi Scott I just dug an example report (that we created for another customer) It generates a report of requirements and the number of times they have been modified: select H.ARTIFACT_ID as RequirementID, R.NAME as RequirementName, X.VERSION_NUMBER as ReleaseVersionNumber, count(H.ARTIFACT_ID) as ModifiedCount from SpiraTestEntities.R_HistoryChangeSets as H inner join SpiraTestEntities.R_Requirements as R on R.REQUIREMENT_ID = H.ARTIFACT_ID inner join SpiraTestEntities.R_Releases as X on X.RELEASE_ID = R.RELEASE_ID where H.PROJECT_ID = ${ProjectId} and H.ARTIFACT_TYPE_ID = 1 group by H.ARTIFACT_ID, R.NAME, X.VERSION_NUMBER RequirementID RequirementName ReleaseVersionNumber ModifiedCount 91 new test req 1.0.0.0 2 92 Ability to edit editions 1.0.0.0 3 4 Ability to add new books to the system 1.0.0.0.0001 7 5 Ability to edit existing books in the system 1.0.0.0.0001 4 6 Ability to delete existing books in the system 1.0.0.0.0002 4 26 Ability to create new users in the system 1.0.1.0.0001 2 9 Ability to associate books with different editions 1.1.0.0.0002 2 72 Ability to archive data in the system 1.1.0.0.0003 4 10 Ability to completely erase all books stored in the system with one click 1.2.0.0 2 Regards Sarah Tue, 23 Feb 2016 18:14:48 -05002016-02-23T18:14:48-05:00/Support/Forum/spiratest/issues-questions/1364.aspx#reply2500messageId=2502Inflectra Sarah (donotreply6@kronodesk.net) To some something similar for incidents you could use: select H.ARTIFACT_ID as IncidentID, INC.NAME as IncidentName, count(H.ARTIFACT_ID) as ModifiedCount from SpiraTestEntities.R_HistoryChangeSets as H inner join SpiraTestEntities.R_Incidents as INC on INC.INCIDENT_ID = H.ARTIFACT_ID where H.PROJECT_ID = ${ProjectId} and H.ARTIFACT_TYPE_ID = 3 group by H.ARTIFACT_ID, INC.NAME IncidentID IncidentName ModifiedCount 1 Cannot log into the application 2 3 6 The book listing screen doesn't sort 4 7 Cannot add a new book to the system 3 62 Bug on archiving system 2 63 just found a bug 2 64 Need to support Windows 10 6 66 bug when clicking link. 2 68 This is a new bug in the system 2 69 bug on create book page 2 72 defect when using the admin tools 2 Regards Sarah Tue, 23 Feb 2016 18:17:40 -05002016-02-23T18:17:40-05:00/Support/Forum/spiratest/issues-questions/1364.aspx#reply2502messageId=2503Inflectra Sarah (donotreply6@kronodesk.net)Also if you wanted to add on Description and current status you could use: select H.ARTIFACT_ID as IncidentID, INC.NAME as IncidentName, INC.DESCRIPTION as Description,INC.INCIDENT_STATUS_NAME as CurrentStatus, count(H.ARTIFACT_ID) as ModifiedCount from SpiraTestEntities.R_HistoryChangeSets as H inner join SpiraTestEntities.R_Incidents as INC on INC.INCIDENT_ID = H.ARTIFACT_ID where H.PROJECT_ID = ${ProjectId} and H.ARTIFACT_TYPE_ID = 3 group by H.ARTIFACT_ID, INC.NAME, INC.INCIDENT_STATUS_NAME, INC.DESCRIPTION Tue, 23 Feb 2016 18:19:42 -05002016-02-23T18:19:42-05:00/Support/Forum/spiratest/issues-questions/1364.aspx#reply2503