Smart Objects and global automation

Bud Herz_4dzuwt

Looking to automate this weekly Slack update - 

RELEASE X.123
Total Tickets >
160 Total Tickets
68 Bugs
81 Stories
5 Tasks

Completed Tickets >
9 tickets completed

Active Tickets >
145 in Active statuses

==================

I am trying to do this with Smart Objects and a Global Automation. I have this working so far - 

@here - These are the new bugs, stories, or tasks --
{{lookupIssues.size}} - TOTAL TICKETS (Bug, Story, Task)
{{lookupIssues.Story Points.sum}}

 

{{#lookupIssues}}
{{/}}

===================

I am hoping there is a way to identify each issue type and list them out like we are doing manually above, but it had eluded me so far. Any ideas?

Bill Sheboy

Hi @Bud Herz 

If I understand your question correctly, and you anticipate more than 100 issues in any category, the Lookup Issues action would not work due to its call limits:

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

 

An alternative would be repeated calls to the REST API endpoint "Count issues using JQL" using the Send Web Request action, and storing the results in variables for reporting.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-approximate-count-post

 

Kind regards,
Bill