JQL filter for tickets that will not make their Due Date considering Original Estimate

Question

I would like to set up a Kanban with RAGed swimlanes - eg tickets with comfortable contingency to complete; (Green); tickets within 1 day (Orange) and tickets without sufficient time (Red). I was hoping I could write filters for this eg:

duedate > now() + ??numberOfDays(Original Estimate) GREEN
duedate < now() + ??numberOfDays(Original Estimate) RED

I was hoping there's an inline date parsing function I could use and avoid writing a Script. Is this wishful thinking?

Krisztian Kovacs_rapuo3 · Answer

With a custom script attached to that page (web fragment) that runs the calculations might work.

https://scriptrunner.adaptavist.com/4.3.3/jira/CustomisingUI.html

Ben Parry · Answer

Thanks Krisz. When would that field get evaluated?

Ideally I'd like it to happen when the board is refreshed (not when the ticket is created) as a ticket that was in the Green/Contingency swimlane yesterday may now be in the expedite swimlane today.

Krisztian Kovacs_rapuo3 · Answer

I'd suggest a calculated custom field with Scriptrunner.

It would put the expected finish date there and that you could use in a filter.

Does that make sense?