You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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