Finding issues with Sprint = NULL (ie the Backlog)

[Nils Söderström]

Hi all,

Im trying to find issues in Jira where the springt value is empty (ie. Backlog). Ive tried several different option that i foudn suggested here but nothing seems to work. The following queries havent worked for me. 

Sprint = NULL

Sprint is not openSprints()

Sprint is EMPTY

I could simply say "Sprint != ... " and then list the sprints we have, but that seems like the wrong way of going about it. Any answers? 

Also, if you have any other ways of finding all backlog issues im all ears. 

Cheers,

Nils 

[Warren · Accepted solution]

Hi Nils

First off, a few questions :

Is this a classic project or next=gen?

Is it a Scrum board or Kanban board?

For classic Scrum, sprint is EMPTY is what you should be using (please not the lower case s for sprint) - what are you seeing that you know it isn't working?

[Nils Söderström]

I tried sprint is EMPTY lower case and it seems to have worked. Odd since "Sprint" works just fine for everything else, I had no idea it was case sensitive. Thanks for helping out!

[Alexey Matveev]

Hello,

Why is the Sprint is Empty not working? You can see issues with the Sprint field set?

[Nils Söderström]

it returned issues both with a sprint set, as well as issues with no sprint. apparently the word "sprint" is in this case sensetive, cuz it worked fine in all lower case. i guess it just omitted the search all together in "Sprint"

[Alexey Matveev]

It means that you also have a custom field called Sprint and it has nothing to do with the sprint field.