Order of operations to create email that contains a list of epics and must have open issues

Jeff Crane

Hello, I am trying to create a daily report that lists the epics in our current fix version and the number of open issues that are must have in each epic.  I have three problems. 

First, I cannot get the issue count to render properly, it is always blank in the email 

Second, and likely related, according to the loggers I put in, my email is sending before the lookup of the issue counts 

Third, when I look at the logs, every issue count is "1"  and that is not the case.

 

Looking for any assistance anyone can provide, I've been trying to figure this out for a week and and I've just hit a dead end.

 

Danut M _StonikByte_

Hi @Jeff Crane,

Welcome to the Atlassian Community. 

You could get something with the Issue Statistics gadget of Jira.

Here is how:

1. Create (and save) a Jira filter that returns the open items under your epics. Its JQL should be like this: project = DEMO AND parent IS NOT Empty AND issueType In standardIssueTypes() AND statusCategory != Done
2. Add the Issue Statistics gadget to a Jira dashboard and configure it to use the saved filter and to display stats by Parent field.  => As a result, you will get the count of unresolved issues under each epic

This is a solution based on Jira native tools. Unfortunately it will not display the key and stats of the epics, but will display the count of unresolved.

If you are willing to try an app from Atlasian Marketplace, a more appropriate view can be obtained by using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. 

All you have to do is to configure the gadget like this:

 

Danut.