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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you able to find any correct logic for above query? I am also finding solutions for same problem.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
your operators seem to be unsupported ones, did you try using
summary != "ABC" (and so on)
Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this one
!(summary ~ "ABC")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.