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

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

Accepted answers

Mayuresh Kamble

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

All comments

Mayuresh Kamble

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.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

due-date

due