query for finding issues 30 Days after Due date

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

5 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

2 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

You rock! Thank you.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.