nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Would love help with creating weekly triggered Slack report on near due and overdue vulnerabilities

Jennifer Neusch

I am trying to create a weekly Slack Report using Jira automation for issues that are near due or overdue and have the Slack alert formatted to show the count of issues in each category and the list of issues with some of their details.

I can trigger the automation successfully when I manually trigger it, but when I try to run the scheduled one, it is sending the message 3 times. I turned off the checkbox for running the rule for all issues triggered as I thought that may be why but I'm now getting new error messages.

I have been branching for Overdue and then a new branch for near due but I don't seem to have a good option for branching. I currently have for Current Work Item, but I can see why that is triggering a message. I have been circling on this for hours over the past 2 days and it's driving me bonkers at this point.

Here are some screenshots of what I'm doing, what I'm seeing and a Slack message that worked when run manually.

Image 7-22-25 at 10.24 PM.jpeg Image 7-22-25 at 10.28 PM.jpeg Image 7-22-25 at 10.31 PM.jpeg

Accepted answers

Bill Sheboy

Hi @Jennifer Neusch

When you want a scheduled rule to run and to send a single message, do not include the JQL in the Scheduled trigger. Instead, use the Lookup Work Items action with the JQL to gather the work items and then iterate over them in the message.

And...rather than use conditions, add all the criteria to the JQL.

For example:

trigger: scheduled, weekly with no JQL
action: lookup work items, with JQL
smart values condition:
- first value: {{lookupIssues.size|0}}
- condition: greater than
- second value: 0
action: send Slack message

I added a smart values condition so the message is not sent when there are no results found. You could instead remove that and tailor the message send a "nothing found" type of message.

Kind regards,
Bill

All comments

Deivid Araujo

Hi Jennifer,

For these types of triggers, you need to apply a filter in the automation. When you check the box, the automation runs based on the JQL query. If you leave it unchecked, you’ll need to perform a search before the branching step.

Have you tried moving the Lookup Issues action before the branch and then branching on the {{lookupIssues}} smart value?

Also, could you share the full automation so I can take a closer look?

Bill Sheboy

Hi @Jennifer Neusch

And...rather than use conditions, add all the criteria to the JQL.

For example:

trigger: scheduled, weekly with no JQL
action: lookup work items, with JQL
smart values condition:
- first value: {{lookupIssues.size|0}}
- condition: greater than
- second value: 0
action: send Slack message

I added a smart values condition so the message is not sent when there are no results found. You could instead remove that and tailor the message send a "nothing found" type of message.

Kind regards,
Bill

Jennifer Neusch

I will try that out now and I can send you the whole automation shortly too. The missing part is almost identical to the overdue items, but it's looking up overdue items instead. I'll get back to you shortly!

Jennifer Neusch

Here is the full automation. I'm doing my best but I'm still a bit of a beginner with the smart values. I did move up the Lookup issues before the branching and changed the action to branch by JQL but seeing the whole automation will likely more make sense b/c one Slack message is being sent for the overdue and near due for the weekly report. Once I changed to the following - I now get one message but no values.

The first branch:

This is the details for the second Set Entity Property:

The second branch details:

Details of the second Set Identity Property in the 2nd branch:

Details for the Send Slack Message after the 2 branches:

Slack message that came this time w/o the values:

And the Audit Log Details:

Thank you so much for offering advice and looking at the details. It's greatly appreciated!
Jennie

Jennifer Neusch

Hi Deivid,

Here are the full details of the automation. And thank you for trying to help me out!

https://community.atlassian.com/forums/Automation-questions/Re-Re-Would-love-help-with-creating-weekly-triggered-Sl/qaq-p/3075275/comment-id/14819#M14819

Jennie

Bill Sheboy

Let's back up a bit: what problem are you trying to solve? That is, "why do this?" and "what does success look like?" That context may help clarify the scenario.

For the rule information you show...

What is the purpose of setting the entity properties?

And if they are necessary, where should the values be stored as the values appear to span multiple work items?

What is the purpose of branching? I was suggesting the use of Lookup Work Items so the branching is not necessary to send a single message.