Automation and smart values

[Fred]

I have an automation that checks what tickets were in To Do on a specific date. 

Smart value documentation indicates I should be able to use the code below to list the tickets and summarize the points. It successfully sends a message to slack, though none of the smart values come through. What am I missing?

{{#lookupIssues}}

* {{key}} - {{Story Points}}

{{/}}

To Do points - {{lookupIssues.Story Points.sum}}

[Bill Sheboy · Accepted solution]

Hi @Fred 

To use that smart value, you first use the Lookup Issues action with some JQL.  Did you include that in your rule first?

If so, something else is up.  Please post an image of your rule and an example execution from the audit log so the community can offer ideas.  Thanks!

Best regards,

Bill

[Fred]

I'm seeing mixed feedback in the forums, are we able to include custom fields in this execution? I've tried all the variations I can think of, and they come back blank.

[Bill Sheboy]

Nope, not yet for Lookup Issues.  Here is the suggestion to add it...and...it has moved to the dreaded status of "Future Consideration"  ;^)

https://jira.atlassian.com/browse/JRACLOUD-75018

As you are using the Cloud version of Jira, the automation has a handy action Create Variable.  So...one work-around for this Lookup Issues limitation is a complicated call to the REST API for JQL with a web request, and regular expressions and text functions to dynamically build your message content.

[Fred]

Okay, that's what I thought. Thanks!

[Fred]

That worked! I added the action - lookup, and success. Thanks guys!

[Bill Sheboy]

Awesome!  I am glad that helped.