Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Incident - How Many Times...

Incident - How Many Times In A Status

Monday, February 15, 2016

workflow

incident status

custom reports writing

itqatestmanagement_impellam

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

3 Replies

Tuesday, February 23, 2016

~~inflectra.sarahx~~

re: itqatestmanagement_impellam Monday, February 15, 2016

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

Tuesday, February 23, 2016

~~inflectra.sarahx~~

re: inflectra.sarahx Tuesday, February 23, 2016

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

Tuesday, February 23, 2016

~~inflectra.sarahx~~

re: inflectra.sarahx Tuesday, February 23, 2016

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

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: Monday, February 15, 2016
Last Reply: Tuesday, February 23, 2016
Replies: 3
Views: 10095

Incident - How Many Times In A Status

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

Edit Thread

Edit Message

Search Results