Due Date is not visible to email ?

Question

Hi All

I have created an automation rule to send email with a list of issues and the valus of due date is not returned. All other values are returned properly.

{{#lookupIssues}}
* {{key}} - {{summary}} - {{duedate}} - {{description}} - {{assignee.displayname}}

Can you please help what I am doing wrong as per above ? The filed name ?

Thank you

Chronis Kalfas · Answer

@Bill Sheboy Yes. The feedback I got is that this is not returned, for performance reasons. So its not because of the syntax.

Bill Sheboy · Answer

Hi @Chronis Kalfas -- Welcome to the Atlassian Community!

Unfortunately due date is not one of the fields supported by the Lookup Issues action:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/#Smartvaluesgeneral---lookupIssues--

And it may not be added due to the possible performance challenges; there is a suggestion to add more fields to that action: https://jira.atlassian.com/browse/JRACLOUD-75018

There are two possible work-arounds for this if you really need the due date in that email:

* easy and a "hack": modify your summary fields to always contain the due date using another automation rule
* much more difficult, and not a "hack": call the REST API from the automation rule with your JQL (from the Lookup Issues action) and use text and list functions to parse out the data into a created variable.  Then put that variable into the email message.

Kind regards,
Bill

Rolf Okken_hxqc2o · Answer

i agree

* {{issue.duedate}} - Returns the issue's due date.