Advance JQL search in JIRA to search for issues not updated for 2 weeks AFTER the due date.

[Eric Sebian]

I tried using the following: project in (cms) AND status not in (Closed, Cancelled, "Backed Out") and updated <='-2w'

but if the ticket was created with a due date 3 weeks out but never updated, the ticket would be flagged after 2 weeks because there was no update. Therefore I figure I need to based the flagging on the due date.  Please advise.

[Milan Chheda [INFOSYSTA] · Accepted solution]

From what I understand, you need to duedate in your JQL. So it should be:

project in (cms) AND status not in (Closed, Cancelled, "Backed Out") and duedate < now() AND updated <='-2w'

Above will search all open issues in project cms whose duedate is expired and are not updated since more than 2 weeks.