Automation for Jira - Validating Issue Counts for WIP Automated Alerts

[Jack Arndt]

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. 

[Dave Sausville · Accepted solution]

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

[Matt Hooper]

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

[John Funk]

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. 

[Jack Arndt]

thanks John, that is super helpful! :)

[yrslv]

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

[Jack Arndt]

No :(

Not sure if it's able to be done.