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

Allison Stewart_nejvgh

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

@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.