nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Alexey Matveev

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", "")

All comments

Alexey Matveev

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_pahcqf

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!

Vinu_pahcqf

Wow @Alexey Matveev This is a easier way!!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql