Can I filter out a component when creating a filter?

[Tim Lankford]

I want to display all issues in a project except for one component, is this possible and how to I do this using JQL?

Current filter: project = CSC ORDER BY Rank ASC

Component to remove: CSC Data Issue

I tried project = CSC IS NOT component = CSC Data Issue but this is not a working string

Any ideas would be much appreciated!

Thanks,

Tim

[John Funk · Accepted solution]

Hi Tim,

Try this: project = CSC and (component != "CSC Data Issue" or component is empty)

[Tim Lankford]

@John Funk 

thanks!  that worked, now I need to filter out 2 components, the other one is "CSC Idea Space"

any ideas on how to do that?

[John Funk]

project = CSC and (component not in ("CSC Data Issue", "CSC Idea Space) or component is empty)

[Tim Lankford]

Thanks!  I am clearly a newbie but I appreciate you!

[John Funk]

Glad it worked for you.  :-)

[Trudy Claspill]

Try this:

project=CSC and component != "CSC Data Issue"

You need to surround the component name with quotes when it includes spaces.

That will retrieve only the issues where the Component field has a value specified and that value is not the one in your filter. Do you also want to retrieve issues where there is no value in the Component field? In that case you would need this

project=CSC and (component != "CSC Data Issue" or component is empty) 

[Tim Lankford]

@Trudy Claspill thanks!  that worked, now of course I need to filter out 2 components, the other one is "CSC Idea Space"

any ideas on how to do that?

[Trudy Claspill]

What @John Funk said. :)

Ironically, my initial response used the "not in" option and then I changed it to != because you mentioned only one Component value.

[Yemi Lawal]

I have two components i need to remove from a pie chart i've created. I've not added them in my saved filter query. But when i create the pie chart in my dashboard i see those 2 components there because the pie chart is built with all components

[Trudy Claspill]

Hello @Yemi Lawal 

<EDIT>

I see that you actually did post your own new Question.

https://community.atlassian.com/t5/Jira-Software-questions/I-need-to-exclude-two-components-from-my-pie-chart/qaq-p/2409127

Please post your new question in a new Question post, rather than adding to an existing post that has been answered and is over a year old.

In your new post please provide the details of your scenario.

What is your hosting type?

Provide a copy of the actual filter you are using.

Show us a screen image of the resulting pie chart and point out where the Components you excluded in your filter are appearing.