I'm trying to help my team with their workload balance, so would like to create an automation that sends an email when there are over 5 issues due on a specific due date.
But, I'm having trouble with the JQL I need to populate a variable with the total number of issues due on the Trigger Issue's due date.
Here's what I have:
{{#=}}{{due = triggerIssue.dueDate}}{{/}}
Where am I going wrong?
Hi @Jaina Mistry,
Welcome to Atlassian Community!
What you have above is an incomplete math calculation, they usually look something like this:
{{#=}}{{issue.Invoice Amount}} * 1.2{{/}}
But instead of using calculation on the due date you could use lookup issues and then use the JQL due = -5d and then check the size on {{lookupIssues}} and then the automation would look something like this:
Thank you, @Mikael Sandberg, this is really helpful!
I'm trying to trigger the automation when an issue is assigned to a user. So I tried using
due = {{triggerIssue.dueDate}}
in lookupIssues.
But when I test the automation, there are no errors. The audit log it shows that the issues did not match the condition.
This leads me to think it's not possible to trigger this on issue creation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you know the size of lookupIssues? I would add a log action to see what {{lookupIssues.size}} returns.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That log action was key @Mikael Sandberg ! I didn't know I could do that.
The variable wasn't getting populated with a value because I did not use the write letter-casing for {{lookupIssues.size}}
Here's what the final automation looks like:
Thanks again for your help, Mikael!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.