Jira automation: send email if original estimate is empty or 0

[Rui Caldeira]

Hi everyone! 
I'm trying to create a simple yet apparently challenging automation that would:

1- run once a day
2- validate if a few tickets (previously filtered) have the Original estimate as EMPTY or equal to 0. If these tickets are found, an email goes out to the reporter/assignee. 

The issue here seems to be with the condition for Original estimate that I don't know what to use it.

I've found a few examples out there but they all seem to use as trigger "When value changes for Time Tracking", which would not be this case. 

Any help? :) 

[Hana Kučerová · Accepted solution]

Hi @Rui Caldeira ,

I recommend to use Scheduled trigger, where you can set, that the rule runs once a day.

There's also checkbox called "Run a JQL search and execute actions for each issue in the query.", which should help you with the second part.

[Hana Kučerová]

@Rui Caldeira you should be able to use JQL search:

originalEstimate is EMPTY OR originalEstimate = 0

[Rui Caldeira]

Hi Hana! 

This works wonders! Thank you so much :) 

[Trudy Claspill · Accepted solution]

Hello @Rui Caldeira 

Please show us the rule you have constructed so far.

If you want a rule to run on a schedule, then you will use a Schedule trigger. In that trigger to can include the JQL for the issues you want to select.

You could build it directly into that JQL to include only the issues that meet your criteria for Original Estimate.

[Trudy Claspill]

Hello @Rui Caldeira 

Why can you not include the Original Estimate criteria into the JQL for the Schedule trigger?

Please show us the entire rule, and explain what you want to accomplish with that rule so that we can give you appropriate guidance.

[Rui Caldeira]

Hi Trudy!
You're right - thanks to you and Hana now I know I can include it in JQL but I thought that was not possible - I think I was just trying to figure out a hard way of doing it xD 

Thanks Trudy!

[Rui Caldeira]

Hi guys, thanks for jumping in :)
My issue is mostly with evaluating if the "Original estimate" field is empty (or has a zero). 
This is what I have:

To set the scheduler and to sent the email those are the easy bits but this original estimate condition is really the hard part because I don't know how to set it properly.