JQL to search Summary field for not contains on multiple values - syntax doesn't work

[Allison Stewart]

Hi,

I have a query to search issues where the summary does not contain multiple different values, but the query is not running correctly. I  believe that I have it set up correctly but would like some help if not.

An example of my query:

issuetype = "issuetype1" AND (summary !~ "ABC" OR summary !~ D OR summary !~ "EFG") ORDER BY reporter ASC

But the results are showing me issues with summary that contains "ABC" and with summary that contains "D".

What is wrong with my syntax??  Thanks.

[Joseph Chung Yin · Accepted solution]

@Allison Stewart -

Hi Allison:

Instead or OR operator, try this -

issuetype = "issuetype1" AND (summary !~ "ABC" AND summary !~ D AND summary !~ "EFG") ORDER BY reporter ASC

Your operator usage of !~ is correct, as for Text field search in Jira/JSM - the valid operators are: ~, !~, is, and is not.

Here is a link on search syntax for text fields in Jira/JSM JQL - https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Allison Stewart]

I used the AND ... and that appears to be working.  But it's counterintuitive.

I want issues where the summary does not contain any of those values.  Not where the summary does not contain all of them together.

Thank you for your help.

[Lakhaman Odedra]

Hi @Allison Stewart 

Did you able to find any correct logic for above query? I am also finding solutions for same problem. 

Thanks 

[Lars Barthel]

Hi @Allison Stewart 

your operators seem to be unsupported ones, did you try using

summary != "ABC" (and so on)

Cheers!

[David Loszewski]

The operator '!=' is not supported by the 'summary' field.

[Nilesh Raut]

Try this one

!(summary ~ "ABC")