How do I filter all the project issues, but exclude ones that was resolved before certain date?

Nicolai Viținschii March 13, 2024

We recently switched the workflow for the projects, and I'm trying to set the filter to get all the issues types in every current status in a query, but I want to exclude those that was resolved [Done] before certain date e.g. 1st of October. 

updated >= "%date%" - shows all the tickets and includes ones that were resolved before 1st of October since they were affected with the new workflow implementation

resolved >= "%date%> - shows only [Done] issues

Combined - shows only [Done] issues

Is there something I'm missing?

4 answers

0 votes
Harsh
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 14, 2024

Hi @Nicolai Viținschii 

If I understand correctly, you want all the issues which are not in DONE and resolved before a certain date i.e. 01/10/2023.

Could you please try - project = XYZ and (status != Done and resolved <= "2023/10/01").

Let me know if it works.

0 votes
Varsha Joshi March 13, 2024

For Jira cloud - I use the following query:

status = Resolved AND resolutiondate < endOfMonth().

You can add -1,-2... to go back in time.

Hope this helps.

 

Nicolai Viținschii March 13, 2024

This will show me only resolved items, I need all statuses

0 votes
Laurie Sciutti
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 13, 2024

Hi @Nicolai Viținschii ~ you want to include issues where resolved is EMPTY:

 

resolved is EMPTY OR resolved > "2023/10/01"
Nicolai Viținschii March 13, 2024

but isn't it excludes all non-resolved items? I still need them in results, just don't need those that was resolved before that date

0 votes
Trudy Claspill
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 13, 2024

Use this:

resolved >= "%date% or resolved is EMPTY

By adding a check against the resolved field, the check can be completed only if the resolved field has data. In the cases where the resolved field is empty the check cannot be completed and issues with no data would be excluded.

Nicolai Viținschii March 13, 2024

for some reason when my query looks like this

project = "%Project Name%" AND resolved >= "%date%" or resolved is EMPTY

the results that are shown disregards the project and show issues across all the projects

David Friedrich
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 13, 2024

Hi @Nicolai Viținschii ,

the reason for this is that with OR you basically start a new filter query. So you're currently asking Jira to show you all issues from Project x that are resolved plus any issue that is unresolved. Put it like this to work:

project = "%Project Name%" AND resolved >= "%date%" or project = "%Project Name%" AND resolved is EMPTY

Trudy Claspill
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 13, 2024

Alternately you can do this:

project = "%Project Name%" AND (resolved >= "%date%" or resolved is EMPTY)

Suggest an answer

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

Atlassian Community Events