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

Query tickets where due date were ever breached

Daria Pavlova_4hhye4

Hi! I need to query tickets as well as all closed tickets where the due date were expired

so I need to collect all tickets (no matter the resolution) where the due date was breached

Accepted answers

Sushant Verma

Hi @Daria Pavlova

Welcome to the community!

You can try :

duedate<now()

Regards,
Sushant Verma

All comments

Sushant Verma

Hi @Daria Pavlova

Welcome to the community!

You can try :

duedate<now()

Regards,
Sushant Verma

Daria Pavlova_4hhye4

@Sushant Verma

I am afraid in this way it will show me al the resolved task that was closed on time but time ago so the due date is in the past

Sushant Verma

@Daria Pavlova Try :

duedate < now() AND status in (Closed, Resolved)

Regards,
Sushant Verma

Daria Pavlova_4hhye4

I need to found out if the due date was ever breached even if the task is already closed

Sushant Verma

@Daria Pavlova I think, Jira does not support this functionality out of the box. There is an issue open for this that you can watch or vote for : JRACLOUD-20727

If you have scriptrunner in your instance, you can compare dates with a JQL query like this:

issueFunction in dateCompare("", "resolutionDate > dueDate")

Regards,
Sushant Verma

Welcome!

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

Quick Links

Find more posts tagged with

jira-core