Automating Rule to send email when item has been sat in same status for more than 3 days

[Emily Bleything]

Hello, 

I am trying to set up a rule that sends an email to certain contacts when an item has been sat in a status for longer than 72 hours. The rule is working, however  I get an individual email for every item. Is there a way to get Jira to publish this information in one email? 

Thank you, 

Emily

[John Funk · Accepted solution]

Hi Emily,

Use this in the text of your email:

<ul>
{{#lookupIssues}}
<li>{{key}} - {{summary}}</li>
{{/}}
</ul>

You can see more guidance here:

https://community.atlassian.com/t5/Jira-Software-questions/Sending-an-email-with-a-list-of-issues-using-Automation-for-Jira/qaq-p/1192501?utm_source=atlcomm&utm_medium=email&utm_campaign=immediate_general_reply&utm_content=topic

[Emily Bleything]

Thank you John.

Is there a way to include custom fields using lookupIssues?

Thanks, 

Emily

[Bill Sheboy]

Hi Emily,

Yes, and...to John's answer: custom fields are not yet supported by the Lookup Issues action.

A more complicated work-around for this is to call the REST API to run your JQL from the automation rule, and then parse the response with text and list functions to get what you need.

Kind regards,
Bill

[Bill Sheboy · Accepted solution]

Hi @Emily Bleything 

One way to do this with automation is to use the Lookup Issues action.  In that case, you would change your scheduled trigger to just be the schedule (not the JQL).  For example:

• trigger: scheduled (no JQL)
• action: lookup issues using your JQL
• action: send the email

One advantage of this approach is you can format the email as you wish and provide extra information.  Please look here for more information about Lookup Issues: https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/#Smartvaluesgeneral---lookupIssues--

Kind regards,
Bill

[Emily Bleything]

Thanks Bill! This has worked :)

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Emily Bleything 

You can try to use Filter subscription to achieve that.

Ravi