nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to filter tickets before it gets overdue?

lorenze larot_jtr666

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,

Accepted answers

Thomas Schlegel

Hi Lorenze,

this JQL should do it: due >= "0" AND due <= 8h

Regards,

Thomas

All comments

Thomas Schlegel

Hi Lorenze,

this JQL should do it: due >= "0" AND due <= 8h

Regards,

Thomas

Tarun Sapra

Generally 8 hour is workday duration, thus I would use something like -

dueDate &gt; startOfDay() AND dueDate &lt; endOfDay()

lorenze larot_jtr666

Hi Thomas,

Thanks for the prompt response,that works like a charm. laugh . Is there also way in JIRA to filer the first instance of a certain transition? (e.g StatusA --> StatusB)

Thanks!

Thomas Schlegel

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.

lorenze larot_jtr666

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software