How to include custom field date in automation message?

[Michael Hsu]

I have an automation rule setup that will send a slack message once a week with a list of overdue tasks. What I'd like to do is to include the custom "due date" field that we created in the actual message itself for each of the tasks. 

Following the instructions here, our custom "due date" has the ID: customfield_10037

However, when I try to include it in the actual automation message, I can't get it show up at all in the output. The variable {{customfield_10037}} is just a blank but I'd like for it to show the actual due date (e.g., "2021-06-30")

{{#lookupIssues}}
`<{{url}}|{{key}}>` - *{{status.name}}* - <{{url}}|{{summary}}> - {{customfield_10037}}
{{/}}

I also tried the following, but none of them worked either:

• {{fields.customfield_10037}} because of the JSON tree structure
• {{issue.customfield_10037}}
• {{issue.customfield_10037.value}}
• {{customfield_10037.value}}
• {{name_of_actual_custom_field}}

What am I doing wrong?

[Alex Koxaras -Relational- · Accepted solution]

Hi @Michael Hsu ,

Take a look at smart value documentation here: https://support.atlassian.com/jira-work-management/docs/smart-values-general/

You will see that custom fields are not supported on the lookupissues (unfortunately). There is a suggestion ticket which you can support.

Alex

[Michael Hsu]

Thanks for your help @Alex Koxaras -Relational-