JQL formula for: Today + original estimate >= duedate

[Dev K]

I would like to list all open issues that will be over due when only started on today. That way I can take action and see what can be done for these issues in terms of shifting due date, parallelise the task, ....

I believe I am looking for something along these lines:

Date of today + original estimate (in days) >= Due date

I can't quite figure out how to sum up today + original estimate

[Alexey Matveev · Accepted solution]

Hello,

You could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL would look like this:

key in silJQLExpression("currentDate() + originalEstimate >= due", "") 

[Vinu]

Wow @Alexey Matveev This is a easier way!! 

[Vinu]

Hi @Dev K

It is not possible from to ask a JQL to do some arithmetic operations. All a JQL can do is to perform logical operations based on the data available.

Having said this, I believe if you have Adaptavist Scriptrunner installed, you can create a scripted field called estimate which calculates the estimate with your original and remaning estimates getting you the number of days left. You can then use this field in your JQL to compare if that exceeds your due date. Just got this idea from your query, but I havent tried out this yet.

The easier option of this would be to filter out issues that may be nearing the due date, save the filter and subscribe it so that you will get a mail with all the issues nearing the due date.

Hope this helps!