Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Creating a custom report ...
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:
Library Information System63
Sample Application One1
Can anyone help?
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