Creating a custom report for Incident detection

Tuesday, April 12, 2022
Avatar

Hi can anyone help in creating a custom report to show which release an incident was detected. I am trying to show the spread pattern to see when we are identifying incidents to see if our new quality measures are improving earlier detection times

I saw a custom report that show an incident count by project, but i do not have the expertise to add releases to the list indented underneath and show a count by detected release

Count of Incidents By Project

The following Entity SQL command can be used in the Spira custom report (custom section) or Spira custom graph administration section to generate a graph of incidents by project:

select INC.PROJECT_NAME, count(INC.INCIDENT_ID) as INCIDENT_COUNT from SpiraTestEntities.R_Incidents as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME

That gives the following data grid:

PROJECT_NAMEINCIDENT_COUNT

Library Information System63

Sample Application One1

Can anyone help?

1 Replies
Wednesday, April 13, 2022
Avatar
re: admin.computacenter Tuesday, April 12, 2022

Please try this:

select INC.PROJECT_NAME, INC.DETECTED_RELEASE_VERSION_NUMBER, count(INC.INCIDENT_ID) as INCIDENT_COUNT
from SpiraTestEntities.R_Incidents as INC
where INC.IS_DELETED = False
group by INC.PROJECT_NAME, INC.DETECTED_RELEASE_VERSION_NUMBER
order by INC.PROJECT_NAME

 

Statistics
  • Started: Tuesday, April 12, 2022
  • Last Reply: Wednesday, April 13, 2022
  • Replies: 1
  • Views: 516