JQL - Due Date is 2 Weeks After Status Change

[Emily Obermeyer]

Hi, 

I am currently trying to complete a JQL statement.

The criteria for this query/filter is that when the ticket is made, the due date is manually changed to be 2 weeks after it is changed to a "In progress" status. 

I am trying to filter that the due date is more than 14 days after the ticket was moved to "In Progress". This will help me find these outliers. 

Is there a way that I can create a JQL filter to search for those that did not follow the guideline using the above criteria? 

[Max Foerster - K15t]

Hey @Emily Obermeyer, and welcome to the community!

The challenging part of your requirement is the connection between the day of the status change, say day X, and the dependency of the due date with it, so X+14. JQL is not built for this kind of relation. Multiple apps available for Jira on all platforms extend the JQL functionality. From the top of my head, I know there is, for example, a dateCompare in Scriptrunner. I'm not sure if it will enable you to build the exact query you need, but it's worth trying. 

Just another thought about your use case, did you consider automating setting the due date instead of relying on users changing it?

Best, Max