nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Thomas Schlegel

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.

All comments

Thomas Schlegel

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira