nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for Updated date/time is greater than Resolved date

S S_5vmrvq

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

Accepted answers

Fabio Racobaldo _Catworkx_

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

All comments

Fabio Racobaldo _Catworkx_

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

Oday Rafeh_2jhprw

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_5vmrvq

@Fabio Racobaldo _Catworkx_ Thank you that worked

S S_5vmrvq

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

Thank you anyway.

Fabio Racobaldo _Catworkx_

you're welcome @S S

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-service-management-cloud

jira-service-management