Service Desk request updated after resolved

Gerhard_Basson

Good day

I want to list service desk requests where an update was made after it was resolved - something like "project = ISD AND status in (Canceled, Closed, Completed, Declined, Done, Resolved) AND updatedDate > resolutiondate order by created DESC".

The JQL does not allow the statement "updatedDate > resolutiondate".

-> Error: Date value 'resolutiondate' for field 'updatedDate' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', ...

 

Is there a way to do this?   

Regards

Elifcan Cakmak

Hello,

Jira doesn't allow comparing two date fields at the moment, I'm afraid. You can use Script Runner plugin's date compare feature for this:

https://scriptrunner.adaptavist.com/4.3.1/jira/jql-functions.html#_datecompare

Regards,

Elifcan