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,293,684
Community Members
 
Community Events
165
Community Groups

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

Edited
Deleted user Aug 09, 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 Aug 09, 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 Aug 09, 2017

Thanks for the quick reply.

Tarun Sapra Community Leader Aug 09, 2017

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

does not work for me

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

it's works for me as well. Thank you

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