query for finding issues 30 Days after Due date

Scott McDonald August 9, 2017

Hello:

Trying to find issues 30 Days post Due Date(field). The ultimate goal is to add these to automation for JIRA but for now, the JQL will work!


Thank you,
Scott

3 answers

1 accepted

5 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
duedate < -30d and resolution is empty

This will get you all unresolved issues which have dueDate before the last 30 days i.e 30 days post duedate 

2 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 9, 2017

Can you try this?

duedate >= -30d and resolution = Unresolved

I added the resolution to clause to only find unresolved issues. You can modify it as needed.

0 votes
Scott McDonald August 10, 2017

You rock!  Thank you.

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 10, 2017

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

Suggest an answer

Log in or Sign up to answer