DueDates

[Katherine Stevens]

Hi!  I'm really new to JIRA.  I'm trying to write a 2 different queries.

1.  I need to see all issues that are more than 14 days past its duedate. 

Example:  today is 10/8/18 and I need to see all issues that were due on or before 9/24/18.

2.  I need to see all issues that have a 14 day gap between it's duedate and planned end date (which is a custom field I created). 

Example:  I have an issue and its duedate is 10/8/18 and it's PlannedEnd is 11/5/18

Any help would be greatly appreciated.

Thanks!

[Thomas Schlegel · Accepted solution]

Hi @Katherine Stevens,

the first one is:

duedate <= startOfDay(-14d) ORDER BY duedate

With plain Jira, you can't compare a duedate with a custom field. You need an additional app like scriptrunner for this, but there may also be others on the marketplace.

[Katherine Stevens]

Thank you @Thomas Schlegel!

[Thomas Schlegel]

You're welcome, @Katherine Stevens. 

If you think, your question is answered, please accept the answer with the checksign. Other users with similar questions can find answered questions much easier that way.

Thank you