Jira Automation smart value list for Parent items in Sprint

Andy Tran_xwzehx

Problem: I've tried several different variations and cannot get the Parent Summary to show up.  I can get list of issues to appear but not the associated Parents.  

What I'm doing: I've created an automation using MS Teams incoming webhook where I post a message in a designated Teams channel when a Sprint starts in Jira. 

The only problem I'm having is trying to get this list of Epics (Parents) Summary to show up in the post.  

As you can see I've tried:
{{#issue.epic}}
* {{issue.parent.summary}}
{{/}}

 

I've also tried just {{issue.parent}} instead of epic as well as other iterations but cannot seem to get it to show up.  Not sure if it's even possible.  

Forgive me, I'm relatively new to this whole automation setup.

Bill Sheboy

Hi @Andy Tran 

You state you are trying to list the parent's summaries (that is, the associated epics for any issues in the sprint which started).

My assumption is only the child issues, and not the Epics, are assigned to the Sprint.

 

Your rule has a few challenges, and so my suggestions would be:

• The rule trigger is Sprint Started, but your Lookup Issues action uses JQL referencing openSprints().  I recommend changing that JQL to specifically reference the sprint which triggered the rule:
  • project = yourProjectName AND sprint = {{sprint.id}}
• The lookup contains the issues in the sprint in the smart value {{lookupIssues}} and that may contain multiple issues (e.g., Story or Task) for each parent epic.  To narrow down the list and have each epic listed once, a second Lookup Issues action is needed, referencing the first, and adding the distinct function.  Perhaps like below.  Please adjust this to handle the cases where there are no issues found in the sprint, as this rule just halts processing.
  • trigger: sprint started
  • action: lookup issues to get the issues in the sprint
  • smart value condition: to check if any issues were found
    • first value: {{lookupIssues.size|0}}
    • condition: greater than
    • second value: 0
  • action: lookup issues to get just the epics, with JQL of
    • key IN ( {{lookupIssues.parent.key.distinct}} ) AND issueType = Epic
  • now the lookup contains the epics, for displaying in your message
  • action: send the message

 

One would think that this would work with the first lookup to get the summaries:

{{lookupIssues.parent.summary.distinct}}

However it appears (surprisingly) that when an issue does not have a parent epic, the "parent" smart value returns the original issue instead of null!

 

Kind regards,
Bill