Custom Report or Graph with Test Cases by Program

Thursday, November 21, 2019
Avatar

Hi,

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 INC
where INC.IS_DELETED = False
group by INC.PROJECT_NAME
order 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

Test Case Status 2Test Case Status 3
Project 1   
Project 2   
Project 3   

 

1 Replies
Tuesday, November 26, 2019
Avatar
re: plamen.sakutov Thursday, November 21, 2019

Hi Plamen,

You need to use something like this:

select INC.PROJECT_NAME, 
        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

Regards

David

Statistics
  • Started: Thursday, November 21, 2019
  • Last Reply: Tuesday, November 26, 2019
  • Replies: 1
  • Views: 1109