How can I run a search without a specific item?

[danielle-branquinho]

Hi, I would like to run a search to include all items but not include specific ones. 

Examples:

1. Show me all items but exclude items with label "project"

2. Show me all items but exclude items that are part of Sprint 17

Is this possible?

Thanks!

[David Blank · Accepted solution]

Hi @danielle-branquinho !

If I understand your question correctly, this is possible.

When you click into search, there should be an option to "View All Issues" at the bottom. If you click this, it will take you to the "Issue Navigator". (You can also just put your cursor into the search field and hit enter)

There you will have the option to use the basic search or Switch to JQL.

If you switch to JQL, for your first example above your JQL would look like:

labels != project

For your second one it could look like:

sprint != 17

I hope this helps! For more on JQL there are tons of resources both on the community and from Atlassian. I will link some below.

Here's a great course from Atlassian:

https://university.atlassian.com/student/page/1225443-intro-to-jql-in-jira-software-course-description

Here's a quick Article:

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

My go-to resource: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

[danielle-branquinho]

Hi @David

This is exactly what I was after! Thank you for this and all the links - very helpful.

Danielle

[David Blank]

Hi @danielle-branquinho

That's great news!

If this answered your question completely would you please mark my answer as accepted so that others know it works?