JQL to return a count of issues due on a specific due date

Jaina Mistry

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?

Mikael Sandberg

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: