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; } } }

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?

Accepted answers

All comments

Trudy P 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.

Laurie Sciutti

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

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

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

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

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 P Claspill

Alternately you can do this:

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

Harsh_v2xlv7

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.

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-cloud

filter

query

resolved