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; } } }

I Am trying to write a JQL with the due date of a story issue

Heinrich Graupner

Hello Jira Community.

I am trying to write a JQL to query issues in a certain status AND where the due date of a certain story issue in that project has been passed.

The reason for this is that we want to insert milestone dates into the story issue and then compare issues in a certain status with a certain milestone date within the story issue, to determine if the specific issue is late to the milestone or not.

This in turn this will then cause the issues on a custom chart to turn red, or not.

According to my knowledge, this is not possible on Jira Cloud as per standard. But this is a case where we hope someone else has experienced the same problem? Another option would be that we need project-wide variables (the milestone dates of the project) so they can be used in a JQL to determine the progress of issues according to milestones.

Any help would be most appreciated.

Best of regards

Heinrich

Accepted answers

All comments

Trudy P Claspill

Hello @Heinrich Graupner

Can you provide sample data that clarifies your need?

Which issues are you looking at for status?

Which issue has the Due date?

Heinrich Graupner

Hi @Trudy P Claspill

See attached screenshots.

We are looking for all types of issues in that certain status.

A story type issue has the dates.

Best of regards

Heinrich Due dates in Story.PNG

Heinrich Graupner

Support from the Atlassian team would be widely appreciated. This is a matter that we hold with very high value to and believe that it would open a lot of doors for other users also.

It would take project management and tracking to the next level!

Trudy P Claspill

@Heinrich Graupner

Note this is a user community. While some Atlassian support personnel may monitor the community, if you want to work directly with Atlassian Support you need to open a support ticket rather than creating a community post. To create a support ticket go to: