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 · Accepted solution]

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

[Gerhard_Basson]

Thank you for the reply.