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

[Bar Azgad]

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>

---

 Features that may NOT delivery on time  :

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

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

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

---

[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]

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]

[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]

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.