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; } } }

Duration more than 30 days query

Elaine Ocson

Hi everyone, I need some help creating an advance search in Jira but I'm not sure if it's possible.

Here's the scenario: I need to retrieve all tickets where, based on the start date and end date, the duration between them is more than 30 days.

Any help is appreciated! Thank you!

Accepted answers

John Funk

Hi Elaine,

One way would be to create a custom number field and then create an automation rule to update the custom field based on a diff between the two dates. Then you could run a query where the value of the custom field > 30.

All comments

John Funk

Hi Elaine,

Trudy P Claspill

Adding to this...

Jira's native search capabilities do you support imbedding in the query a comparison of two date fields nor a calculation of the difference between date field and criteria for the query.

Are you willing to consider a third party app if one could give you the date differencing capability directly in the query?

Elaine Ocson

Got it, thanks so much John and Trudy! As a quick workaround I just exported the list of tickets in a spreadsheet and added a formula there. Thanks again!

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-data-center

data-center

duration

startdate

enddate