Service Desk request updated after resolved

Gerhard_Basson December 11, 2019

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

1 answer

1 accepted

1 vote
Answer accepted
Elifcan Cakmak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 12, 2019

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 December 12, 2019

Thank you for the reply. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events