JQL for Updated date/time is greater than Resolved date

[S S]

How to write a Query to find the issues which were already resolved but the status is not resolved or completed or resolved?

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @S S ,

please try the following JQL :

resolution is not EMPTY and status not in (Resolved,Closed,Completed)

Please modify status list at your convenience.

Hope this helps,

Fabio

[S S]

@Fabio Racobaldo _Herzum_ Thank you that worked

[Fabio Racobaldo _Herzum_]

you're welcome @S S 

[Oday Rafeh]

Hi @S S , 

Here is also another JQL you can try  : 

resolutiondate IS NOT EMPTY AND updated > resolutiondate AND status NOT IN (Resolved, Completed, Closed)

[S S]

Hi @Oday Rafeh That didn't work. It's showing an error message as below.

Thank you anyway.