Hello,
How do we filter tickets before it gets overdue? is there a way to filter ticket that are 8 hours away from its due date?
Thanks,
Hi Lorenze,
this JQL should do it: due >= "0" AND due <= 8h
Regards,
Thomas
Hi Thomas,
Thanks for the prompt response,that works like a charm. . Is there also way in JIRA to filer the first instance of a certain transition? (e.g StatusA --> StatusB)
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, of course. Create a custom field of type Datetime and add it to your project.
In the transition, add a post function, which fills the custom field with the current date and time if it is not already filled.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there another way to filter it rather than adding additional custom field? or maybe an add-on that would be able to track a transition and present it into a filter or dashboard?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lorenze,
main problem is, that you want the date, the transition was executed first. I don't think that you can get this date without a custom field.
Do you have the Script Runner Plugin? If so, here's another solution for your problem (but also with a custom field): https://answers.atlassian.com/questions/250963
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Again for the response Thomas. Appreciate it. I'll check on scriptrunner
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Generally 8 hour is workday duration, thus I would use something like -
dueDate > startOfDay() AND dueDate < endOfDay()
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.