Want to send slack message - number of issues

Question

I want to send slack message every morning like below

But the results of JQL is over 100.

How can I set Jira Automation?

Slack message :

MM/DD Total issues : XX

Blocker : XX / Critical : XX / Major : XX / Minor : XX / trivial : XX

I used below code at Jira automation, but it isn't working.

*{{now.format("MM/DD")}} Total issues*: {{lookupIssues.size}}

- Blocker: {{lookupIssues.filter(i => i.priority == "Blocker").size}}

- Critical: {{lookupIssues.filter(i => i.priority == "Critical").size}}

- Major: {{lookupIssues.filter(i => i.priority == "Major").size}}

- Minor: {{lookupIssues.filter(i => i.priority == "Minor").size}}

- Trivial: {{lookupIssues.filter(i => i.priority == "Trivial").size}}

홍신영 · Answer

@Mikael Sandberg @Bill Sheboy

I will check the documents and try again using REST API. Thanks!

Bill Sheboy · Answer

Hi @홍신영 -- Welcome to the Atlassian Community!

Adding to Mikael's suggestion:

Here is a how-to article for calling a REST API endpoint from an automation rule using the Send Web Request action: https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

Kind regards,
Bill

Mikael Sandberg · Answer

Hi @홍신영,

Welcome to Atlassian Community!

Since the lookupIssues only return the first 100 issues that it finds, your only option would be to use  the Count issues using JQL endpoint, both for the total and for each priority. So basically your automation would have 6 different web request components to get the totals.