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

Question

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 · Answer

Of course, happy to help!

akovinchick · Answer

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

Alex Christensen · Answer

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.