Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Custom Report or Graph wi...
I am trying to find a way to show All test cases by Project and Status. I looked in the the build in Reports, but I couldn't find. I tried creating custom one, but I ended up by
select INC.PROJECT_NAME, count(INC.TEST_CASE_ID) as INCIDENT_COUNT from SpiraTestEntities.R_TestCases as INCwhere INC.IS_DELETED = Falsegroup by INC.PROJECT_NAMEorder by INC.PROJECT_NAME
I want to be able to show the table below in a report or graph. Can anyone help please.
Test Case Status 1
You need to use something like this:
sum(case when INC.EXECUTION_STATUS_NAME = 'Passed' then 1 else 0 end) as PASS_COUNT,
sum(case when INC.EXECUTION_STATUS_NAME = 'Failed' then 1 else 0 end) as FAIL_COUNT,
sum(case when INC.EXECUTION_STATUS_NAME = 'Not Run' then 1 else 0 end) as NOT_RUN_COUNT
from SpiraTestEntities.R_TestCases as INC
where INC.IS_DELETED = False
group by INC.PROJECT_NAME
order by INC.PROJECT_NAME