How do I exclude a component from search?

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?

5 answers

1 accepted

Comments Closed
This widget could not be displayed.

You've got "= is" at the front. That's two operators in one place. Decide which one you want to use and remove the other. I'd tend towards "is not" as it's a little more readable than !=

This widget could not be displayed.
Joe Wai Tye Atlassian Team Sep 10, 2013

Hi Greg,

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 :)

This widget could not be displayed.

you should't use "component = is not "Component Name"" like this.

you have to use like component != "Component Name"

This widget could not be displayed.

That was it.

Thanks!

This widget could not be displayed.

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.

Any suggestions?

I would ask this again as a new question.  The original conversation is almost 5 years old and things have changed.

However you are nearly there - try combining the empty clause with an or on "not in xyz"

Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

573 views 25 15
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