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

Allison Stewart
Contributor
October 17, 2022

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.

2 answers

1 accepted

2 votes
Answer accepted
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 17, 2022

@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
Contributor
October 25, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 27, 2023

Hi @Allison Stewart 

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

Thanks 

0 votes
Lars Barthel
Contributor
October 17, 2022

Hi @Allison Stewart 

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

 

summary != "ABC" (and so on)

 

Cheers!

David Loszewski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 20, 2023
The operator '!=' is not supported by the 'summary' field.
Nilesh Raut
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 21, 2023

Try this one

!(summary ~ "ABC")

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events