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

Accepted Answer
0 votes
Henning Tietgens Community Champion Feb 24, 2014

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
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

77 views 0 3
Join discussion

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