I am working on JIRA Cloud and would like to get a list of records where a certain comment does not appear.
This works perfectly when the JQL is comment ~ "String" but the opposite does not. I have tried using comment !~ "String" or NOT (comment ~ "String") also single quotes around String.
Lastly, the String = Baseline so it does not have any special characters.
Many thanks in advance!
the search for "comment !~ String" or "NOT (comment ~ String)" probably does not work because JQL checks if any other comment exists that does not contain the text.
Since JQL does not support subqueries / subselects in a direct way, the only solution I can think of is a little complicated.
Please make sure that after saving the filter in second step, reset the search form not to show the "MyCommentFilter" anymore, otherwise Jira will display an obscure error message about cyclic dependencies.