Serching for issues not assigned to a sprint

[Ashley Swearingen]

I'm very new to Jira and I have been asked to create a filter that will display issues that have not been assigned to a sprint yet. I'm not very comfortable with creating custom JQL queries yet but I have tried,  Issue = sprint empty, issue = sprint null and all variations of these without luck. Would love some help. Thank you!

[Mikael Sandberg · Accepted solution]

What you are looking for are instances were sprint if empty, so this query should do it:

sprint is EMPTY

[Ashley Swearingen]

YES Thank you!! 

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hi @Ashley Swearingen ,

please try the following JQL

Sprint not in openSprints()

or

Sprint is empty

Hope this helps,

Fabio

[Ashley Swearingen]

this worked! Thank you. I was able to add this and narrow it down to the specific project and found what I was looking for. Thank you so much! 

[Fabio Racobaldo _Catworkx_]

you're welcome @Ashley Swearingen 

[Trudy Claspill · Accepted solution]

Filters generally used to get a collection of issues that match criteria, so to create a filter you need to specify the criteria you want the issues to match.

@Mikael Sandberg provided the quick answer to finding the issue that have not been assigned to a sprint.

If that is used in the general Search Issues screen it will search for all issues visible to you that are not assigned to a sprint.

If that is used as a Quick Filter within a board, then it will be added to the filter for the board so you would see only the issues within the scope of that board that have ALSO not been assigned to a sprint.

There are several videos available on YouTube if you would like to follow up with some training on how to create custom searches and filters. There is also quite a lot of documentation available from Atlassian. Here is a starting point:

https://support.atlassian.com/jira-software-cloud/docs/perform-a-basic-search/

[Ashley Swearingen]

This is very helpful! Thank you!!