Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Filter closed tickets by date/period


Could you please help me with JQL syntax to find closed tickets per certain period of date?

I tried:

  • resolved >= 2021-09-01 AND resolved <= 2021-09-09 AND project = CB ORDER BY created DESC
  • closed >= 2021-09-01 AND closed <= 2021-09-09 AND project = CB ORDER BY created DESC
  • done >= 2021-09-01 AND done <= 2021-09-09 AND project = CB ORDER BY created DESC
  • resolutiondate >= -7d
  • resolved >= -7d
  • status changed to Closed after -30d
  • resolutiondate >= -1w AND project = CB

Thank you in advance for the help.

2 answers

1 vote

So in the first three, you are using date comparisons correctly in theory at least.

Taking just one of the clauses as an example to explain:

closed <= 2021-09-09

in human speak says "the date held in the field called closed is less than or equal to 9th September 2021".  That's a perfectly good question (and to clarify "is less than", that comes out as "before" when talking about dates, because behind the scenes the dates are actually "number of seconds elapsed since 1st Jan 1970", so the larger the number, the later the date)

However, "closed" is not a field in Jira, unless you've added a custom field for it.  I guess that you mean "date/time that an issue transitioned from a status into another that we consider closed", and it's not unusual to see people add custom fields to do this and then have a post-function set the data to "now" when the issue is closed.

But I suspect you've not done that yet!

On the other four, those will work as you expect, so I'm a bit stuck on what you need help with!

This is what worked for me, edit as needed:

project = {{PORJECT_ID}} AND issuetype = "{{ISSUE_TYPE}}" AND status in (Closed, Rejected, "Rolled Back") AND status changed BEFORE 30d

This is showing me the tickets that have been closed in the last 30 days.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events