Automation Rule | Sum up linked issue count and update the same on the parent issue

Summary

Scenario: Consider the below Jira issues:

• Issue A (parent issue)

• Issue B, Issue C (linked to A)

• Issue D, Issue E, Issue F (linked to B or C)

Requirement: You wish to capture the total linked issues count on the parent issue (Example: Count of B, C, D, E, F issues and add it to Issue-A)

Flow: When the automation rule is triggered from Issue A, it should calculate the count of all the linked issues (up to 3 levels) and then sum up in log action.

Solution

Set up the automation rule :

Trigger: Manual trigger

Lookup issues:

• JQL: issue in linkedIssues(key)

Create variable:

• Variable name: count

• Smart value: {{lookupIssues.size}}

Create variable:

• Variable name: jql

• Smart value:

  • ({{#lookupIssues}}issue in linkedIssues("{{key}}", "is caused by"){{^last}} OR {{/}}{{/}}) AND issue not in ({{#lookupIssues}}"{{key}}",{{/}}"{{triggerIssue.key}}")

Lookup issues:

• JQL: {{jql}}

Create variable:

• Variable name: totalCount

• Smart value : {{#=}}{{count}} + {{lookupIssues.size}}{{/}}

Log action :

• Log message: count: count --- total: totalCount

Explanation :

1st Lookup issue

• Lookup 1: Lookup issues: issue in linkedIssues(key)

  • The JQL query in this look-up section would check all the linked Issues in the key in our example it is Issue ASo the result it would return is Issue B and Issue C

1st Create Variable

• Create variable 1

  • Create variable :

  • Variable name: count

  • Smart value: {{lookupIssues.size}}

    • We have created a variable name "count" to keep a tab of the number of issues in the current issue, that we would need to call in future. In our example, it would be 2 as B and C have been added on A. When checking from B or C it would include , E, F that count size 3

2nd Create Variable

• Create variable 2

  • Create variable :

  • Variable name: jql

  • Smart value :({{#lookupIssues}}issue in linkedIssues("{{key}}", "is caused by"){{^last}} OR {{/}}{{/}}) AND issue not in ({{#lookupIssues}}"{{key}}",{{/}}"{{triggerIssue.key}}")

    • Defining variables to fetch the linked issues on the Issue and exclude Parent issue-A further. We will use this variable further

Lookup Issues 2

• LookUp issue 2 query

  • Lookup issues :

  • JQL: {{jql}}

    • This would return the Output of the above query would beOutput(issue in linkedIssues("Issue-A") OR issue in linkedIssues("Issue-B", "Issue-C")) AND issue not in ("Issue-A","Issue-B","Issue-C")

3rd Create Variable

• Create variable 3

  • Create variable :

  • Variable name: totalCount

  • Smart value : {{#=}}{{count}} + {{lookupIssues.size}}{{/}}

    • In this variable, we are performing calculation by performing addition of {{count}} and {{lookupIssues.size}}.

    • It would be 2+ 3

    • Output : 2+ 3 = 5

Here is the automation rule JSON file to import: