Hello,
is it possible to compare two dates (Created - Updated) with a JQL Query. I would like to know the average duration of an Issue!
Best regards,
Martin
Average Duration of an Issue is available in "Average Time in Status" gadget.
And for getting days between dates, use script runner and add a scripted field which can get the difference between Created and Due dates.
def diff = new Timestamp(issue.getDueDate().getTime() - issue.getCreated().getTime()).getTime() def days = (int)(diff/ (1000 * 60 * 60 * 24)); return days
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Script Runner has a date compare JQL Function
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
anybody find a good way to do this? We're trying to report stories that are late by comparing a due date with release date.
A custom field with that does the day difference would be great. Anybody have ideas?
thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can't do this with a JQL query. Write a custom report or see if there are any existing ones in marketplace.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.