I need to display test coverage by comparing two JQL query results

My effort is to run two JQL queries, that compare results and output a percentage.

 

eg 

issueType = userStory AND created >= 2015-09-01 AND created <= 2015-12-31 AND project = project 1

vs

 

issueType = subTask AND created >= 2015-09-01 AND created <= 2015-12-31 AND project = project 1

With these results (my subTask is actually an issueType of Acceptance Test) I can see that query #1 returns 285 results and query #2 returns 245 results. Simple math shows me that I have 86.95% coverage. Great! Now how can I have this displayed on a Team Space in Confluence?

 

 

percent.png

2 answers

Are your subtasks, subtasks of the user stories which they test? If so, do you have the script runner plugin available?If so, you could do a query something like:

created >= 2015-09-01 AND created <= 2015-12-31 AND project = project 1 and (issueType = subtask or (issuetype = userstory and issueFunction not in hasSubtasks()))

Script runner is required to only get the userstories that don't have subtasks. There may be other plugins to do the same thing.

If you have a query that gets the subtasks and stories without subtasks, you can put it in a pie chart to see the percentages. 

The subTasks should be children to the userStory. Q1 is pulling all userStory (equals 285) and Q2 pulls all subTasks (245). I need to compare those two query results as a percentage.

If you want to use one of the Jira gadgets to display percentage, you need to do a single query. I'm suggesting you query the subtasks, plus all the stories which don't have a subtask, in a single query. This will give you 245 subtasks and 40 user stories in the query for a total of 285. If you put that query into a Jira pie chart gadget and differentiate the pie slices by issuetype, you get a pie chart with the percentages you want. The query above does what you want in my Jira system. However, it relies on the presence of the ScriptRunner plugin.JQL function "issueFunction not in hasSubtasks()". If you have the ScriptRunner add-on, or another add-on which lets you query issues without subtasks, this will work.

Updated with a screen shot.

Using the equivalent of the JQL in my answer above, in my system I generated this graph:

Samplegraph.png

In my graph, the task issue type is a subtask of the Defect issue type. there are 5063 Defects, 874 of them have a task subtask.

I don't know how to do what you want in native Jira. I used a ScriptRunner plugin JQL function to enable this. What plugins to you have available?

Unfortunately, we're running the Cloud serviced JIRA. No Script Runner for me.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

867 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you