JIRA Automation is not Retrieving Story Points

[Swapnil]

Hello Folks,

My goal is to create a Sprint Hygiene Report using JIRA Automation for an ACTIVE sprint ( a sprint which is started and currently in progress).

Following is the structure of the automation -

1. Automation Name - Hygiene Report Publisher 19

2. Trigger - 
Schedule: Fixed Rate of every* 1 Days

- run a JQL search and pass results to subsequent conditions and actions

JQL : project = <ProjectName> AND sprint in openSprints() 

3. LookUp Issues Action

JQL: project = <ProjectName>AND sprint in openSprints() AND component in ("ComponentName") AND Sprint is not EMPTY AND issuetype in (Story, Task, Bug) and Sprint is not EMPTY ORDER BY key

4. Send Email Action

To: my-email@abc.com

Subject: JIRA Hygiene Report - {{sprintName}}

Content:

Hi All,<br><br>

<table border="1" cellspacing="0" cellpadding="6" style="border-collapse:collapse;font-family:Arial,sans-serif;font-size:12px;">
<thead style="background:#f4f4f4;">
<tr>
<th>Key</th>
<th>Issue Type</th>
<th>Summary</th>
<th>Status</th>
<th>Story Points</th>
</tr>
</thead>
<tbody>{{#lookupIssues}}<tr>
<td><a href="https://jiradc-awm.prod.aws.jpmchase.net/browse/{{key}}">{{key}}</a></td>
<td>{{issuetype.name}}</td>
<td>{{summary}}</td>
<td>{{status.name}}</td>
<td>{{#if(equals(customfield_11483, ""))}}
<span style="color:#b71c1c;font-weight:700;">Not Pointed</span>
{{/}}{{#if(not(equals(customfield_11483, "")))}}
{{customfield_11483}}
{{/}}</td>
</tr>{{/lookupIssues}}</tbody>
<tfoot>
<tr style="font-weight:700;background:#f9f9f9;">
<td colspan="4" align="right">Total Ready</td>
<td>{{lookupIssues.customfield_11483.sum}}</td>
</tr>
</tfoot>
</table>

---

The above automation has the following issues (ranked in priority of importance)

1. The contents doesnt not retrieve story points (numerical values) even when the jira (story/bug/task) is assigned with story points. And the "Story Points" name is populated as "Not Pointed". The automation reads story points as empty and hence marks it as "Not Pointed".

2. Sprint Name appears blank in the subject line.

Appreciate any leads on solving the above challenges.

Thank you in advance!

[Habib__Plugio__]

Hi @Swapnil 

Two separate causes here:

Story points showing empty — first verify customfield_11483 is actually the field holding the values: open https://<your-instance>/rest/api/2/issue/<SOME-KEY>?fields=customfield_11483 in a browser for an issue you know is pointed. If it returns null, you're referencing the wrong field — instances commonly have multiple story points fields (on Cloud, "Story Points" and "Story point estimate" are different fields depending on project type).
If REST does show the value but the email doesn't, and you're on Data Center, older Automation for Jira versions return only a limited field set from Lookup Issues — add a Log action with {{lookupIssues.first.customfield_11483}} to confirm.

Blank subject — {{sprintName}} isn't a smart value, so it renders empty. Since your JQL already scopes to open sprints, use {{lookupIssues.first.sprint.name}} instead.

Hope this helps.