Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

JQL Query for Tickets resolved less than 24 after their logged

I am trying to put together a query in JIRA that covers the following criteria:

  • The ticket was logged last month - I know I can use endOfMonth(-1) and startOfMonth(-1) for this.
  • Tickets that we closed within 24 hours of the created date.

I wondered if someone can point me in the right direction please?

2 answers

1 accepted

0 votes
Answer accepted

Hi @Colin Young 

JQL is not a SQL, so you cannot compare different fields within a single query as you ask with out-of-the-box Jira: e.g. resolved within N time units of created.

To do that you would need a marketplace add-on for JQL to enhance the query or an improved reporting tool, or you could try these work-arounds:

  • Brute force: export the data and compare the data in a spreadsheet
  • Automation and Save the results: use an automation for Jira rule and a custom field to save the difference between resolved and created, and then query on that custom field
  • Automation and JIT: use a scheduled automation rule to compare things resolved in the last N time units, and report on the differences between created and resolved.  If you know a threshold value of interest, this could be a smaller result set.  For example, issues that took longer than 24 hours to resolve.


Best regards,

Bill

Hi @Colin Young Welcome to Community!

You can try something like this :- 

 

project = "JIRA Support" AND issuetype = "New Project Request" AND status changed to closed BEFORE "2020/12/01" AFTER "2020/11/30 00:00"

Thanks

Vikrant Yadav

Thank you Vikrant.

I think I am looking for something more dynamic like

project = "JIRA Support" AND issuetype = "New Project Request" AND status changed to closed BEFORE created+1d

It doesn't like using created after BEFORE. 

If you don't want to use BEFORE AFTER use DURING

status changed to "closed" during ("2020-06-03", "2020-06-07")

 

Thanks again Vikrant.

I think I need to avoid using static dates. The main idea is to get tickets that were closed last month and within 24 hours of them being created.

I can create the query that shows all tickets from current month -1. I just can't get the closed within a day part of it :(

Tried this but JIRA aint happy

status changed to resolved during (created, created\u002b1d)

Suggest an answer

Log in or Sign up to answer
TAGS

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