Example: Test Runs by Status for a Release
In this example, we will show you how to create a simple donut Graph of incidents that are part of Component 1 in the current project. The graph will be a donut Graph with current incidents status as the 'axis', filtered by the specific project, component, and the IS_ACTIVE_STATUS flag set to True.
Using the option to Create a Custom Graph, we entered this information:
This then gave the following data grid and donut graph:
The actual Entity SQL we used was this:
select R.EXECUTION_STATUS_NAME as ExecutionStatus, count(R.TEST_RUN_ID) as Count
from SpiraTestEntities.R_TestRuns as R
where R.PROJECT_ID = ${ProjectId} and R.RELEASE_ID = 1
and R.IS_DELETED = False
group by R.EXECUTION_STATUS_NAME
Which is hard-coded to filter on Release ID = 1.
In future releases of Spira (v6.4 and newer) you will be able to use the new ${ReleaseId} field to specify the current release, rather than hard-coding it.