I want to exclude a component name from a search.
When I try to add Not, Not In, Is Not from this query:
component = is not "Component Name" AND status in (Open, "In Progress", Reopened) AND assignee in (mzhilin) ORDER BY priority DESC
I get this error:
Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'is'. (line 1, character 23)
What am I doing wrong?
Perhaps you could try replacing the '= is not' with '!=', for example, like this :
component != "Component Name" AND status in (Open, "In Progress", Reopened) AND assignee in (mzhilin) ORDER BY priority DESC
Please give this query a try and see if it suits your requirements :)
I'm on JIRA 7.1.8 and none of the "not" operators work. In my case, I want a filter for issues that don't contain a component called XYZ. In the test project (PROJ) the issues either contain a component named XYZ or the component field is empty. In the future I plan to have a mix of blank component fields and some issues that have one or more components in them.
If I say "project = PROJ AND component = XYZ" or "project = PROJ AND component in (XYZ)" I get all the issues with that component. This is expected.
If I say "project = PROJ AND component != XYZ" or "project = PROJ AND component not in (XYZ)", I expect to see all the issues that have a blank component, but instead I get "No issues were found to match your search".
If I use the "project = PROJ AND component is EMPTY" I will get all the issues where the component field is empty. While you may think this is what I want, it isn't. I want is all issues where the components are empty OR any any issues where the component is NOT XYZ.
This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...
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!
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