Smart values in Jira Automation do not work

OLHA SHCHEPILOVA
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 13, 2025

PRECONDITIONS:
1. We have 1 Jira project named "Apple"
2. As a Scrum Master I want to have a scheduled Email sent by Jira Automation, with the list of tickets according to specific JQL.
3. Expected Email format:
- I want to see total number of completed features yesterday
- I want to see total number of completed bugs yesterday
- I want to see the list of completed features (clickable key, status, summary)
- I want to see the list of completed bugs (clickable key, status, summary)

Expected Email to receive: 
Features completed yesterday: Total 3
KEY(link) - STATUS - SUMMARY
KEY - STATUS - SUMMARY
KEY - STATUS - SUMMARY

Bugs completed yesterday: Total 3
KEY - STATUS - SUMMARY
KEY - STATUS - SUMMARY
KEY - STATUS - SUMMARY

WHAT I HAVE NOW:

When: Scheduled

every 1 Days

Then: Lookup Issues 
JQL* = project = "Apple" AND (status changed to (Done) during (-1d, now()) AND issuetype in ("Feature"))

And: Create variable
Variable name* = CompletedFeatures
Smart value* = {{lookupIssues}}

And: Lookup Issues 
JQL* = project = "Apple" AND (status changed to (Done) during (-1d, now()) AND issuetype in ("Bug"))

And: Create variable
Variable name* = CompletedBugs
Smart value* = {{lookupIssues}}

And: Send Email

Features completed yesterday: Total ???????????
???????????

Bugs completed yesterday: Total ???????????
???????????

1 answer

2 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 13, 2025

Hi Olha - Welcome to the Atlassian Community!

Set the variables with the totals to: {{lookupIssues.size}}

OLHA SHCHEPILOVA
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 13, 2025

Hi John and thanks for your interest.
I followed your advice and now I can see the Total for Features and Bugs, thanks!

- Features completed yesterday:
{{CompletedFeatures}}
- Bugs completed yesterday:
{{CompletedBugs}}

5202009864761632422.jpg

How can I add the list of items found to the email?

 

Terry Dance
Contributor
January 13, 2025

I haven't tried it, but creating a variable using each {{lookupissues}} should show the list. Or creating the variable with {{lookupissues.key}} should show the list. Replace ".key" with ".summary" for the summary. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events