I would like to display the total amount of linked open tickets in my active ticket.

[Tom Goode]

All of our tickets are linked to an Epic ticket based on a custom field selected. The automation that does that is below. What I would like to do is count the number of linked tickets that are in the Epic and in open status for the last 7 days and present that total it a custom field for the agent. The reason we would like to do this is so that the agent can check if there are any open tickets to keep from keeping duplicate issues open. 

[Bill Sheboy · Accepted solution]

Hi @Tom Goode 

Where would someone look to see this count you describe?

As I expect you can write JQL to count those for a specific epic, you have several options:

• add the custom field, and set it with an automation rule and the Lookup Issues action (with the JQL above), making it visible with the issue (Epic)
• create a saved filter with the JQL, and share it with the users who need to see (or subscribe to) it
• create a dashboard to show your epics in various ways, using the JQL

Kind regards,
Bill

[Tom Goode]

Thanks again Bill. I would like to see it on the child ticket. 

[Bill Sheboy]

Tom, what do you mean by "child ticket" in this context where you are using links?

Do you meant that every single issue would have the custom field and show how many of the linked issues are "open" for that 7 days window of time? 

If so, I suspect that would be a risky rule to run given the upcoming changes in rule execution limits.  The reason is such a rule would need to trigger whenever an issue is created, deleted, or transitions status...and then potentially walk and count the issues for each issue in the tree.  That could lead to a self-triggering rule loop.

[Tom Goode]

That is actually a good point that I have not thought of. At this point it does not look like there is any other way around this unless we do it manually. Thanks once again @Bill Sheboy !