Automation

[gemma.whitfield]

Hi,

I'm trying to use the 'Task is due in X days - send email reminder' automation template so that we can get email reminders when a ticket is due in 3/5/7 days.

However, we are not getting any reminders, even though tickets are due. 
I have looked in the audit logs and it says the rule had a successful run. I can't seem to find where I'm going wrong here and why we are not receiving the emails?

Any help would be much appreicated.

Thanks

[gemma.whitfield]

Hi both,

I am using Jira's pre-built template, I did not build this rule from scratch.

This is the JQL statement for the first LookUp issues action:

duedate <= endOfDay({{numberOfDaysBeforeDueInclusion}}) AND statusCategory != done AND assignee != empty

[John Funk]

Hi Gemma - Welcome to the Atlassian Community!

Can you share an image of your rule here? 

[gemma.whitfield]

Hi John,

Thanks!

Here is my rule:

[John Funk]

Thanks for that. Can you share the details of the Audit log when it runs?

And the email @live.com doesn't arrive either? 

[John Funk]

Also, you probably want to log out the values returned from the lookupIssues to be sure there is indeed values there. 

[gemma.whitfield]

Thanks John, here is the latest audit log, it does indeed seem to be related to the lookupIssues as you suggested:

[Bill Sheboy]

Hi @gemma.whitfield 

Adding to John's suggestions...

Would you please show the action where you create the variable?

Would you please copy the JQL statement you are using for the first Lookup Issues action, and write that to the audit log?  That will help confirm what JQL is being used when the rule runs.

And...why use a variable when the value could be used directly in the JQL for the lookup issues action?

Kind regards,
Bill

[gemma.whitfield]

Hi both,

I am using Jira's pre-built template, I did not build this rule from scratch.

This is the JQL statement for the first LookUp issues action:

duedate <= endOfDay({{numberOfDaysBeforeDueInclusion}}) AND statusCategory != done AND assignee != empty

[John Funk]

We need the details of the Variable - not the JQL statement. 

[gemma.whitfield]

Variable name: numberOfDaysBeforeDueInclusion

Value: 3

[John Funk]

Why don't you just use 3 as the value instead of creating a variable and assigning the value of 3 to the variable?