It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

I want to create a filter that will include having the created date = to the resolved date

I want to create a filter that will include having the created date = to the resolved date: it has to be opened and closed on the same day.  

3 answers

Not a solution, just a hint.

Maybe you could define an SLA for tickets to be resolved within 24h (or 8h if your just looking at the workday). Then you could filter for tickets breaching or not breaching this SLA.

Is there a way to make that SLA retroactive?

Yes I think so. As soon as you set up a new sla, Jira should recalculate all affected tickets.

Meg Holbrook Community Leader May 09, 2018

Resolved tickets won't update with new SLAs as far as I'm aware. 

0 votes


In the out of the box functionality in JIRA there is not way to do this. You could check out some plugins such as Scriptrunner, but the basic functionality doesn't provide it.

0 votes
Meg Holbrook Community Leader May 07, 2018

I disagree that this isn't possible, but the solution I see also isn't elegant. 

Are you mainly looking to report on these issues? From your request it sounds like that's what you might be doing. The JQL below will show you any items that were created on or after the start of the day but also resolved on or after the start of day. You can swap out start and end of day for specific days. You'll always want the two days to match. 

Created >= startOfDay() and resolved >= startOfDay()

Add in any number of OR modifiers between each date set and you've got yourself a filter.

(Created >= "2018/01/04" and resolved >= "2018/01/04") OR (Created >= "2018/02/04" and resolved >= "2018/02/04") OR (Created >= "2018/03/04" and resolved >= "2018/03/04")

If you're looking for an easier/more expansive set of features, I agree with Kian that you'd be better off with an addon. I know that's additional resources and configuration that not every team has available though. 

Maybe we were just looking at the question in two different ways! I interpreted as "return all tickets that were created and resolved in the same date".

I guess I considered the answer you've provided but I didn't really think it addresses how I interpreted the question. That being said, I could have misunderstood what was being asked. 

The solution you provided would return issues created/resolved on the specific days you are filtering for!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Desk

Tell us how you've implemented Change Management

Hello Community 👋, I'm a product manager at Atlassian, looking at improving change management capabilities across our products. In particular, we're looking at bridging the gap between Dev & ...

1,870 views 10 17
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you