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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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
4,459,268
Community Members
 
Community Events
176
Community Groups

Filter closed tickets by date/period

Edited

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
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events