EMPTY resolution is filtered when I don't want it to.

I'm trying to find all issues except subtasks types that have resolution set to Duplicate or "Won't Fix". The only filter that I got to work is :

project = <name> AND type in standardIssueTypes() OR project = <name> AND resolution not in (Duplicate, "Won't Fix") OR project = <name> AND resolution in (EMPTY)

This appears to work, but excluding the subtasks set to Duplicate/Wont Fix is implicite. I would much prefer a direct way to do this. I tried this:

project = "Q-I UX" AND type in standardIssueTypes() OR project = qiux AND type = subTaskissuetypes() and resolution not in (Duplicate, "Won't Fix")

But in this filter excludes subtasks with an EMPTY resolution, even though I did not specify that. I could change it to "resolution in (...)" but then I need to add each resolution type (we have a lot) and update it any time the resolution types list changes.

Any ideas?



3 answers

1 accepted

0 votes
Answer accepted

You should use brackets if you combine ORs and ANDs.

Regarding your last comment, how does this work:

project = "Q-I UX" and not (type = Sub-task and resolution in (Duplicate, "Won't Fix"))

Thanks. I didn't know I could use "AND NOT". That fixed it.

When I used simple ANDs with brackets, the brackets would get stripped out on execution.

Just so you're aware, this search query implicitly filters out all sub-tasks where resolultion is EMPTY.

This means your results will not list any sub-tasks that are unresolved. The 2nd answer I posted yesterday will get you what you're looking for.

Here you go:

project = "Q-I UX" AND type != Sub-task AND resolution in (Duplicate, "Won't Fix")

Sets your project, sets your type to not include sub-tasks, sets resolution to include Duplicate and Won't Fix only.

Your title also states you don't want it to filter EMPTY, so here is that JQL.

project = "Q-I UX" AND type != Sub-task AND (resolution in (Duplicate, "Won't Fix") OR resolution is EMPTY)

hmm, not quite. :) This filters out all subtasks regardless of resolution and filters out standard issues types set to (duplcate,Won't fix). I only want to filter out the subtasks that have resolution set to (Duplicate, Won't Fix). All other issue types / resolutions should be listed.

Ironically, this filter shows me the list of issues that I want to exclude. Is there a filter that shows ALL issues in my project except these:

project = "Q-I UX" AND type = Sub-task AND resolution in (Duplicate, "Won't Fix")

How about

project = "Q-I UX" AND NOT (type = Sub-task AND resolution in (Duplicate, "Won't Fix"))

Apologies, misread your request. Your second filter is very close to what you're looking for.

project = QIUX AND type in standardIssueTypes() OR (type = Sub-task AND (resolution not in (Duplicate, "Won't Fix") or resolution is EMPTY))

That will show all resolutions for standard issue types, and show all sub-tasks (including EMPTY) except for Duplicate and Won't Fix.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Thursday in Jira

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

318 views 1 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you