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?

Thanks,

-SN

3 answers

1 accepted

0 vote
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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot