Jira Automation to send notification when queue reaches certain size

Question

Hello! Is there a way to have a Jira Automation fire off a Slack message when a specific queue in a project reaches a certain size? My team has a process where we are all hands on deck if our new/unassigned tickets reach a certain number, and it would be awesome if I could automate notifying our team Slack channel. I was thinking of trying to set up an SLA and then using the SLA threshold breached automation, but those are all based on time and not quantity :(

Basically, when a new issue is created, I want to trigger a process that will check that all tickets in our project that meet the following criteria is less than 10:

status in (Acknowledged, New) AND resolution = Unresolved AND assignee in (EMPTY)

Any ideas or advice greatly appreciated!!!

Trudy P Claspill · Accepted Answer

I believe you can do this with Jira Automation. Take a look at this post

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Automation-for-Jira-Validating-Issue-Counts-for-WIP-Automated/qaq-p/1345074

...and specifically at the response from @Dave Sausville

Dirk Ronsmans · Accepted Answer

Hey @Maegan Burleigh ,

Since you would like to do this on an issue created that should be no problem!

You can set your trigger on the "issue created" and then preform a JQL with your queue JQL (which you mention above) using the "LookupIssues" component.

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

That component then basically returns a dataset of issues in the {{lookupIssues}} smartvalue on which you can do a some actions.

There is a limit tho on that lookupIssues component that it will only return a maximum of 100 issues, so I hope your limit is below that :)

I would think that you can then add a "create variable component" optionally to which you assign the {{lookupIssues.size}} smartvalue. (or just use it directly in the next step)

Next step would then be to do a Condition component that checks that variable for a specific size and if it is true to use a "send slack message" action

If you don't want to do this on each issue create you could also use a Scheduled trigger to run every x minutes but then it would be near time instead of real time.