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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How about
project = "Q-I UX" AND NOT (type = Sub-task AND resolution in (Duplicate, "Won't Fix"))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.