Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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


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
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

723 views 7 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you