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

[Nicolai Viținschii]

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?

[Harsh]

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.

[Varsha Joshi]

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]

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

[Laurie Sciutti]

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

resolved is EMPTY OR resolved > "2023/10/01"

[Nicolai Viținschii]

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

[Trudy Claspill]

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]

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]

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]

Alternately you can do this:

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