JIRA total number of linkedissues to a story

Question

Hi,

based on this filter:

"type = Story AND summary ~ "PE Spike" AND issuetype = Story AND status = Closed"

...I need the number (sum) of linked bugs to each story

e.g. Story xy -> 5 linked bugs.....

And after that i would like track this with the pie-chart gadget.

does anyone of you has an idea how to get this all ?

thx

Hannes

Piotr Bojko · Answer

You can extend you JIRA with addons, like https://marketplace.atlassian.com/1218767 .  There, you could create more or less following query in a builtin SQL navigator,:

SELECT ST.Key, COUNT(IS.ID) 
FROM TABLE(JQL("KEY", "ID" "type = Story AND summary ~ "PE Spike" AND issuetype = Story AND status = Closed")) AS ST
JOIN ISSUELINKS AS IL ON ST.ID = IL.SOURCE
JOIN ISSUES AS IS ON IL.DESTINATION = IS.ID
WHERE IL.OUTWARD = "Caused by" 
AND IS.ISSUETYPE = 3
GROUP BY ST.Key

Tarun Sapra · Answer

Out of the box you can't perform this kind of aggregation on the JQL search results.

To implement what you want, and if you have the script runner plugin installed. Then you can easily do it by creating a scripted field and using that scripted field to display number of bugs linked to the story. And then display this scripted field in the "issue navigator" view against each story.