Searching issues except CPR

[Sagar Mali]

Hi All,

I want to search all issues except "CPR" issues, how do we search ?

Thanks in advance..

[Valerie Knapp]

Hi @Sagar Mali , thanks for your question.

You can use the Not In in the JQL query, like this

type NOT IN (CPR)

Please can you test this and give us your feedback if this resolves your issue?

Cheers

[Sagar Mali]

assignee = currentUser() AND resolution = Unresolved order by updated DESC AND NOT IN (CPR)

This is not working. 
In "Key" field "CPR" issues are there

[Valerie Knapp]

Hi @Sagar Mali , I understood you meant that CPR was an issue type, my apologies for the confusion.

You should try this instead to search for text.

description !~ "CPR"

So the full query would be this-

assignee = currentUser() AND resolution = Unresolved order by updated DESC AND description !~ "CPR"

Hope that helps.

[Nic Brough -Adaptavist-]

How are you telling Jira that an issue is a "CPR issue"?  Issue type?  Project?  Content of a field?

[Sagar Mali]

Type CP Patch Request

[Nic Brough -Adaptavist-]

Ok, so you can add a clause for "and issuetype != 'CP Patch Request'"

[Sagar Mali]

It worked, thanks