Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Filters - Advance issue search - JQL

Edited

I was wondering if anyone had a piece of JQL which can help me with the following. Any help will be greatly appreciated. 

Tickets carried forward into month

A piece of JQL I can add which will show me Jira tickets which were created before the first of the month but were closed and open on or after the first of the month . So for example tickets which were created before the 1st of November but were closed and still open on or after the 1st of November.

Outstanding tickets

A piece of JQL which will show all tickets which were open for a specific date. For example if I'm on the 13th of December and I wanted to know outstanding tickets for the 1st of December. 

1 answer

1 accepted

1 vote
Answer accepted

Hello @Shabbir Hassan 

Welcome to the community.

For tickets that carried forward into the month:

There is not a built in time stamp for the Closed Date for issues, but there is one for the Resolution Date, which is often the same thing. You could use this filter

createdDate < startOfMonth() and (resolutiondate is empty or resolutiondate >= startOfMonth()) order by created DESC

@Trudy Claspill many thanks, that's my carried forward filters sorted :) 

For your second filter the filter would be

createdDate =< "2021-12-01" AND resolved >= "2021-12-01"
Like Shabbir Hassan likes this

Many thanks @Trudy Claspill for your help. I managed to find this one too which works well for me.

created < 2021-12-01 AND (resolution = Unresolved OR resolved >= 2021-12-01)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

246 views 1 5
Read article

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