Automation to send an Email if number of Unassigned tickets are more than 10

[Rajat Bhattarai]

Hi Team, 

I was wondering if someone could answer my query. I am looking to apply automation that will send an email if the number of Unassigned tickets is more than 10. 

Has anyone done this before? I managed to create a jql , i.e PID=XX, and Assignee=Empty but can't find a way to add the value for it. Any help will be much appreciated. 

[Serosoft Jira Administrator]

Hi @Rajat Bhattarai Please follow these steps:

1. Create a "Scheduled Automation" which may run say everyday 9 am

2.  Add Component->Add an Action->Lookup Issues

3. Use JQL like "project ="xxx" and assignee is Empty

4. Add a condition->Advance Compare Condition->{{lookupissue.size}} ->Greater than->10

5. Add an Action->Send Email

Let me know if it helps. If you wish I can explain further. 

[Rajat Bhattarai]

Hey Sudhendu, 

Thank you for your reply. But I am having a problem getting this to work. 

I have this condition in place, 

(project in (XXX)) AND (assignee is Empty) AND ( statusCategory != Done)

and Advance compare is 

{{issue.size}} is greater than 10. 

The problem is, it is not sending me an email after that condition is met. 

If I get rid of 1 bracket on "issue.size", as in like this {issue.size} , it will send me email every scheduled time no matter the condition but when I implement the one you suggested, it doesn't send me any email at all. Any ideas?

[Sanjog Sigdel]

Hello @Rajat Bhattarai Welcome to the community.

You can trigger an email when you have unassigned tickets to a certain numbers. All of these are configurable:-

Hope this is useful.

[Rajat Bhattarai]

[Sanjog Sigdel]

Hi Rajat,

Somewhere below the JQL fetching action these should be a checkbox. It indicates whether to fetch the entire results again or fetch only the latest results from last execution. Is that the missing part? Your Automation rule looks fine from what you have mentioned