Need to count the number of Total Linked Issues and Open Linked Issues using Automation

[Gaurav]

Hello All,

We have a use case where we need to count the number of Total Linked Issues and Open Linked Issues for a given issue type.

There are 2 Custom Issue Types 'Alpha' and 'Beta'. Each 'Alpha' can be linked to multiple 'Beta' issues, but each 'Beta' is only linked to a single 'Alpha' issue.

We need to display the count of Beta issues on every Alpha issue, both as Total and only Open ones.

I have tried using Automation but have not been successful. Kindly help me with this.

Please note: Additional plugins are a constraint and we need to implement using Automation only.

[Alex Koxaras -Relational- · Accepted solution]

Hi @Gaurav 

Try the following smart values and you will get the values you seek:

• Total number of issues: {{issue.issuelinks.size}} 
• Total number of resolved issues:  {{lookupIssues.size}}
  • Prior of placing the above value, create a lookupissue with the following jql issue in linkedIssues({{issue.key}}) and resolution = unresolved

Hope that helps!

[Gaurav]

Hello @Alex Koxaras -Relational- 

Thanks for the response. This really helps.

I have one follow-up question, is it possible to separate the inward and outward links? For some cases we need to count only for the Inward Links rather than all linked issues.

[Alex Koxaras -Relational-]

My best guess would be to use the issue link function on your JQL:

https://support.atlassian.com/jira-work-management/docs/advanced-search-reference-jql-fields/#Advancedsearching-fieldsreference-issuelinktypeIssuelinktype:~:text=top%20of%20page-,Issue%20link,-Searches%20for%20issues

[Gaurav]

Thanks @Alex Koxaras -Relational-