Why does a JQL statement like (component not in ("MoD Migration", "MoD Migration - CQ") not pick up empty components. I have to add "or component is Empty" to pick up empty components.

[John Love]

Attempting to find all issues I a particular project where the Component is not one of 2 particular values. Unfortunately, this does not return any issue with and Empty value. I have tested this in our production instance (5.2) and our dev instance (6.2). The results are the same.

[Tarun Sapra · Accepted solution]

component not in ("a",b") and component is empty and project = "xyz"

because "not in" is not the same as "is empty" thats how it's designed

[Nic Brough -Adaptavist-]

Yup. Is empty means look for no value. Is not x means look for all items where a value is set and it is not x