The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to show issues that were submitted with a Duedate 2 days or less out from Createddate?

Deleted user
August 9, 2017

We are tryign to track issues that were created yet only have a due date that is 2 days or less out.  Anyone have any suggestions?

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes
Answer accepted
Tarun Sapra
Community Champion
August 9, 2017

Date compare isn't supported yet by JIRA . Open issue here - 

https://jira.atlassian.com/browse/JRASERVER-20727

But there are plugins available which provide additional JQL function. Like "Script Runner" plugin has plenty of JQL of functions and your requirements can easily be implemented by using the query

issueFunction in dateCompare("", "created +2d > dueDate")
Deleted user
August 9, 2017

Thanks for the quick reply.

Tarun Sapra
Community Champion
August 9, 2017

If it works for you, then please accept/upvote the answer. Thanks.

Tom Powers
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2020

does not work for me

Tom Powers
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 6, 2020

This works.  Filters: Shows me issues that do not have a 7day lead time or the due date is blank

created >= -1d AND due <=  6d or duedate is EMPTY

Nadya Domracheva
June 12, 2022

it's works for me as well. Thank you

TAGS
AUG Leaders

Atlassian Community Events