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

Your Points Tracker
  • 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
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?
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 for find issue resolved in next 3 days

Hi Team,

I want this kind of JQL to show how many tickets will be closed in the next 3 days.

Please suggest.

Thanks In Advance.

2 answers

1 accepted

2 votes
Answer accepted

Hi @Gajanan Sasane,

That seems more like fortune telling than JQL, if I may open this one with a wink 😉

You cannot filter for things that are unknown. However, if you are using due dates on your issues, you can filter for those issues having a due date in the next 3 days like this:

due <= StartOfDay(3) 

This will select all issues with a due date smaller than or equal today + 3 days. You can extend your filter to this:

due <= StartOfDay(3) AND resolution = Unresolved

if you only want to return issues that aren't resolved yet.

Hi @Walter Buggenhout _ACA IT_,

Great, this works.
I used the due date field in my issue.
Thanks for your suggestion, I appreciate it.

Hi @Walter Buggenhout _ACA IT_

I have a confusion, above mentioned JQL showed also past due date issues.

Please suggest.@Walter Buggenhout _ACA IT_,

Jack Community Leader May 26, 2021

If you wish to exclude issues that are still open but we’re do greater than three days from now then consider the following. 

due <= StartOfDay(3) AND due > StartOfDay() AND resolution = Unresolved
Like # people like this
0 votes
Moses Thomas Community Leader May 26, 2021

@Gajanan Sasane  I don't thing this make any sense in JQL language. This is more like writing a  script to resolve tickets in next three 3days.  We can get info from JQL once they are resolved


Kind regards,


Hi @Moses Thomas,

Thanks for your quick response.

Let me check with the script.

Suggest an answer

Log in or Sign up to answer
Site Admin

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