Smart Objects and global automation

[Bud Herz]

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 · Accepted solution]

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

[Bud Herz]

Hi @Bill Sheboy  
You raise a great point. Our current release for example has 160+ tickets and that smart object only returned 100. 

Thanks for the tip. I'll check it out.