Want to send slack message - number of issues

[홍신영]

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

[Mikael Sandberg]

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.

[Bill Sheboy]

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 @Bill Sheboy 

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