How can I search on issues that will be overdue based on the "remainingEstimate"

[Vincent Depoortere]

I want to be able to add an interval to a date. E.g. I would like to be able to add the following criterium in a JQL statement: duedate < (now() + remaingEstimate).

How can I accomplish this?

Thanks!

Vincent.

[JamieA · Accepted solution]

Take a look at the jql functions in the script runner plugin. It lets you do things like:

issueFunction in expression("resolution is empty", "remainingEstimate + today > duedate")

The first part is a jql query, the second part is an expression that will filter these further... but have a look at the docs.

[Vincent Depoortere]

Thanks, that did it!