JQL search query

[Jaeson Hillary]

I want to get issues or projects which are unresolved or open and not updated within 12 months.

Thanks in advance.

[KAGITHALA BABU ANVESH]

Hello @Jaeson Hillary ,

Good Day …!

To Get the unresolved issues : issues may be in other workflow statuses, but resolution is not set

JQL : resolution is EMPTY and updated <= -365d ORDER BY updated DESC

If want to open issues and there is no update happened on issues

JQL: status = open and updated <= -365d ORDER BY updated DESC

-------------------------------------------------

To know general updated date on projects

If you are Jira admin the following will be helpful

Settings --> Projects --> 

Thanks.

[Trudy Claspill]

Hello @Jaeson Hillary 

Welcome to the community.

Here are two resources to help you learn about advanced searching:

https://www.idalko.com/jira-jql/

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Here are some filters that might work, depending on your JIRA project configuration:

statusCategory!=Done and updatedDate<"2020/01/20"

updatedDate<-52w and resolution is empty

[Tessa Tuteleers]

Hi @Jaeson Hillary , 

welcome to the community! 

The following JQL would work for you: 

resolution = Unresolved AND updated <= -52w

Then you get all unresolved issues that have an updated date more then 52 weeks (12 months) in the past 

Hope tis helped! 

- Tessa