How to remove a sprint from filter but keep items that have an EMPTY sprint field?

[akovinchick]

Hi-

I'm trying to create a filter of "Open bugs" and I want to remove any of the open bugs that we've scheduled for "Phase 2" (which is the name of a sprint). When I attempt to use a filter such as sprint != "Phase 2" it also removes open bugs that are not associated to a sprint and where the sprint field is EMPTY. This does not give me an accurate picture of open bugs we need to complete in Phase 1. How can I create this filter to make sure bugs that do not have a sprint are shown and anything in Phase 2 is removed?

Thanks in advance for any help!

[Alex Christensen]

You should be able to write some JQL that looks like this (using some example since I don't know what your full filter is):

project = ABC and issuetype = Bug and resolution = Unresolved and (Sprint != "Phase 2" or Sprint is EMPTY)

JQL typically automatically excludes empty/null values when searching, and this is usually my workaround for that.

[akovinchick]

Thanks for the quick reply @Alex Christensen :) That worked, appreciate your help. Happy Holidays!

[Alex Christensen]

Of course, happy to help!