Custom filter to know when the issue changes to a specific state after the due date

[Matteo Napoleoni]

Hello,
I am trying to create a filter that tells me when an issue has been moved to a specific state (i.e. closed) after the due date.
I have tried this:

project = TEST AND assignee = xxxxxx AND status changed to Closed AFTER due

and I got this error:

Date value 'due' for predicate 'after' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

But it seems that function due does not support the AFTER operator.
Is there a way to solve this problem or another type of function that does what I'm looking for? Thanks!

Best regards,
Matteo

[Mayuresh Kamble · Accepted solution]

Hi @Matteo Napoleoni ,

I don't think you will be able to filter the issues based on this JQL because you will need to specify a date next to the keyword "AFTER".

Regards,
Mayuresh

[Matteo Napoleoni]

Hi @Mayuresh Kamble ,

Thank you for the reply, so is there no possibility of extracting this data from the database in another way?
I could use Excel, but I don't want to have to do this work manually.

Best regards,

Matteo

[Mayuresh Kamble]

Hi @Matteo Napoleoni ,

Not sure about a plugin or database query that will help you achieve what you are looking for.