Board Filter for Issues that do no contain a one of many components?

[Matthew Volpe]

Trying to create a board filter that shows tickets that do not contain one of many components.  

Where A, B, C, D, & E are the component values;

I've tried... 

component not in (A, B, C, D, E)

AND

component != A OR component != B OR component != C OR component != D OR component != E

...but neither work.

I'm fairly confident this is something relatively simple that I'm looking, but I can't figure it out.  

HELP!  (thanks) 

[Gautam Pal · Accepted solution]

Something like this works instead.

(component is EMPTY OR (component is not EMPTY AND component not in (A, B, C, D, E)))

[Jack Brickey]

Wouldn’t that simplify to…

component is EMPTY OR component not in (A, B, C, D, E)

[Gautam Pal]

Yep that would work too.. just found it easier to understand its either empty, if not shouldn't be one of..

[Jack Brickey]

@Matthew Volpe, when you say neither work how are you coming to that conclusion? The first one should work but to test this can we step away from the board for a minute and try a simple test? Go to the Search issues view and enter the “component not in (A,B,C,D,E)” into advanced JQL query. Looking at the results does it give you what you would expect? If so then we can focus on emulating in the board.

[Matthew Volpe]

@Jack Brickey Thanks for the help here!

I am concluding that neither filter work because the results are not what I would expect.  Said another way, when I run the "component not in (array)" variant, issues that do not contain one of the components in the array are not shown. 

I tried running the JQL in an advanced issue search (outside the board, as you suggested) and the results were the same.  The results were consistent between the board and the advanced issue search.

For context, what I am trying to do is create a filter that displays issues in a project that do not contain at least one of the components from a predetermined list. 

[Jack Brickey]

Ok while this certainly could be a bug my head is not there yet. Rather I think there is more likely an explanation. Can you please provide screenshots for the following:

• the results of your JQL query search
• the Issue Detail view for an issue that is not shown that you would expect to be shown. I want to see what is listed in the Components field for the issue not being included.

This filter - component not in (A,B,C,D,E) should return a list of all issues in all projects that do not have any of the listed components. In other words it should return issues where the Components is Empty AND where the Components has anything other than A,B,C,D,E. The exclusion would include both singular components, A or B or... as well as any combination, A and C for example.

[Dave Lucente]

If you do something like this, it should give you what you need.

On my Board, I use two Quick Filters to carve out my Issues around Planning:

• All Issues - No Filter Clicked
• Just Planning - Component = A
• No Planning - NOT (Component = A) or Component is EMPTY

I can only assume that Empty identifies as Null instead of a True or False, so you need to include Empty for the absence of a Component. If every Issue has at least one Component, then I believe NOT (component = A) will work without the need for Component is EMPTY.