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

[Ben Parry]

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]

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?

[Ben Parry]

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]

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]

Thanks Krisz - I thought as much - better roll up the sleeves and write a script.. I haven't done this before. Can I consider the script as an external, custom function that could be used in JQL. If not I guess I'd need to abandon the idea of having swimlanes based on likelihood of breaching a due date.

[Krisztian Kovacs]

hi there,

there is no parsing in JQL.

I assume you'd like to add the number of days to the duedate and then based on the calculated date you'd determine which category it falls into?

You'd have to write a script.

Sorry for being the bearer of bad news.

Cheers,
Krisz