JQL for Updated date/time is greater than Resolved date

S S March 20, 2023

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

2 answers

1 accepted

0 votes
Answer accepted
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 20, 2023

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 March 20, 2023

@Fabio Racobaldo _Herzum_ Thank you that worked

Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 20, 2023

you're welcome @S S 

0 votes
Oday Rafeh
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.
March 20, 2023

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 March 20, 2023

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

Thank you anyway.

Like Oday Rafeh likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events