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

2 votes
Answer accepted
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 9, 2017

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

Tom Powers March 5, 2020

does not work for me

Tom Powers 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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events