The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Bar Azgad
January 12, 2025

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


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




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

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



:warning:
 Features that may NOT delivery on time :warning: :

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

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

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


 

 

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Danut M _StonikByte_
Atlassian Partner
January 13, 2025

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. 

image.png

Danut.

 

Bar Azgad
January 14, 2025

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
January 14, 2025

Screenshot 2025-01-14 at 10.25.32.png

0 votes
Aron Gombas _Midori_
Community Champion
January 13, 2025

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
January 13, 2025

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.

 

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events