Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,294
Community Members
 
Community Events
168
Community Groups

Automation for Jira - Validating Issue Counts for WIP Automated Alerts

Hey Gang!

I have a cool use case that I am wracking my brain to solve using Automation for Jira. I would greatly appreciate any help in solving this.

 

Use Case:

As a developer, I want to receive a slack notification whenever WIP space opens on our active sprint, so that I can pull more work and be awesome at my job.

 

Example workflow:

In Progress -> QA Review -> Product Review

 

Automation Logic (part I am having trouble with is in bold):

When a ticket transitions to the workflow step "Product Review", count the number of tickets that are in "In Progress" or "QA Review".

If there are less than 12 tickets in "In Progress" or "QA Review"

Then send a slack alert. 

3 answers

1 accepted

0 votes
Answer accepted
John Funk Community Leader Aug 06, 2020

Hi Jack (and @yrslv )

I don't think that automation can count the number of tickets in a status at one time, but you should be able to create a running total and use that to determine whether to email or not.

So, create a custom number field and default the value to zero. 

Then use automation to increment the value of the custom field by one based on an Issue Transition trigger. 

Also create a rule to subtract the value with another Issue Transition trigger as cards move out of the status. 

Do the same with additional new custom number fields as needed. 

It's a very round about way to do it, but I think it should work for you. 

thanks John, that is super helpful! :)

Like John Funk likes this

As long as your result set is expected to be <= 100, try using the "Lookup Issues" action. 

  • You enter your JQL (be as precise as possible so as not to breach the 100 results limit)
issuetype in ("In Progress", "QA Review")
  • Results are returned as a smart value list named  {{lookupIssues}}
  • Then use the list size function in "Advanced Compare IF"
{{lookupIssues.size}} < 12

 

Here's a sample of how I've used something similar.  Hope this helps

IssueCount.png

This is the best answer. Works great with no funny business.

Jack, I have the same trouble. Did you solve your problem?

No :(

Not sure if it's able to be done.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events