Query tickets where due date were ever breached

[Daria Pavlova]

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

[Sushant Verma · Accepted solution]

Hi @Daria Pavlova 

Welcome to the community!

You can try :

duedate<now()

Regards,
Sushant Verma

[Daria Pavlova]

@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]

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