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; } } }

Generating Custom Slack Reports with JQL Queries for Monthly & Quarterly Delivery

Bar Azgad_9k7ec5

I need to send a monthly report in a Slack channel for each team in my R&D group (using a different channel each time). The report should include a few sections based on the following JQL queries, which are working as expected:

1. Quertly Features -
issuetype = Epic AND statusCategory in (2, 4) AND status != "Deployed Internally" AND "Committed Due Date [Date]" is not EMPTY AND Team in (Maui) AND "Committed Due Date [Date]"> 4w and "Committed Due Date [Date]" < 12w ORDER BY cf[10219] DESC

2. Monthly Features:
issuetype = Epic AND statusCategory in (2, 4) AND status != "Deployed Internally" AND "Committed Due Date [Date]" is not EMPTY AND Island in (Maui) AND "Committed Due Date [Date]" < 4w ORDER BY cf[10219] DESC

3. Features In Risk:-
issuetype = Epic AND statusCategory in (2, 4) AND status != "Deployed Internally" AND "Committed Due Date [Date]" is not EMPTY AND Island in (maui) and "Committed Due Date [Date]" < 7d ORDER BY cf[10049] ASC, cf[10219] ASC, created DESC

My issue is to make the visualisation of the report and shows the features one by one in the following structure

@here

Features that should be ready for delivery in the following Month :
KEY - <Summary> : <Due Date>

Features that should be ready for delivery in the following Quarter:

<KEY> - <Summary> : <Due Date>

<KEY> - <Summary> : <Due Date>

" width="21" height="21" /> Features that may NOT delivery on time

" width="19" height="19" /> :

<KEY> - <Summary> : <Due Date>

Accepted answers

All comments

Aron Gombas _Midori_

The "Send Slack message" automation action should be able to do this!

See: https://confluence.atlassian.com/automation070/how-to-use-slack-messages-with-automation-for-jira-1014664546.html

Bar Azgad_9k7ec5

I know how to send the slack message, my challenge is displaying issues one by one in their relevant sections.
I plan to use a variable to store relevant data for each condition and display it accordingly.

Danut M _StonikByte_

Hi @Bar Azgad,

Would it work to create a Jira dashboard or a Confluence page that lists those issues, and then share it on Slack?

You could use the native Filter Results gadget / macro to list the issues from your filters in the desired format.

Danut.

Bar Azgad_9k7ec5

Hey,

I really want this report shared on Slack to encourage discussions with the PM, developers, and group manager, similar to what’s shown in the screenshot. I created the report using Make (a third-party automation tool), but the automation setup turned out to be quite complicated and I would like to do that using Jira.

Bar Azgad_9k7ec5

Screenshot 2025-01-14 at 10.25.32.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud