Need help in listing out tickets in slack messages via JIRA automation

Question

Hi Team, I am trying to configure a JIRA automation that sends slack messages as a reminder for tickets that needs to be investigated that are in a specific status for more than 5 days, I am able to do the configurations and slack messages are received, but the format is kind of not pleasing. So I have attached the screenshot of the message payload in the JIRA and the screenshot of the slack notification that I received in channel. I need the heading to be a constant at the top of the message and not to be repeated for each tickets. Can someone please help me to achieve this?

Rakhesh Mohan · Answer

This solution worked perfectly!! Thanks a lot @Daniel Eads .

Daniel Eads · Answer

Howdy @Rakhesh Mohan , and welcome to the Community!

Switching the rule to use a Lookup Issues action will populate an array of issues that you can reference from the Send Slack Message action.

I would suggest a rule like this:

When: Scheduled (probably one time a day on weekdays?)

Action: Lookup Issues

You've probably got the JQL for this already - this is where your filter for the issues being in the status more than 5 days goes.

Action: Send Slack Message

Here's the trick - we'll iterate over the list from the last action using the lookupIssues function:

:warning:  *The following tickets are In Progress for more than 5 days and require your attention!* :warning:

{{#lookupIssues}}
* <{{url}}|{{key}}> - {{summary}}
{{/}}

That should print each issue on its own line without re-printing the header message (or footer, if you include one after the list as well).

Cheers,
Daniel

Bill Sheboy · Answer

Hi @Rakhesh Mohan -- Welcome to the Atlassian Community!

Without seeing your complete automation rule, I am making some guesses to help.  For a question like this, please post images of your complete rule and audit log details; those will provide context for the community to offer suggestions.

Until we see those...

As you are using the {{issues}} smart value I am guessing you are on Jira Server or Data Center version.  Is that correct?

If so, please try using the bulk-handling option as that will treat the trigger (or branch) results as a set and so only run once.  Please look here for more information on that: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html

Kind regards,
Bill