searching for text in a comment

Question

I'm trying to find all issues that do NOT contain a comment that has the string CCB in it.  I've created a filter, FILTER_NAME and used the 'filter != FILTER_NAME' , added a search that includes comment !~ CCB , put that in quotes:  comment !~ "CCB"  and nothing works.

Any ideas?  Thanks in advance!

Chuck Miksis · Answer

Hi Jack - sorry for the delayed response ...

that did not work - I tried lots of combinations:

project = "TEST"  AND NOT TEXT ~ "CCB#"

project = "TEST"  AND NOT COMMENT ~ "CCB#"

What does the # mean?  I tried without that as well and that did not work.  It did not matter if I used single or double quotes either.

thanks for your help!

Jack Brickey · Answer

Hi Chuck, welcome to the community.

Maybe something like this will get you what you're looking for?

project = "TEST" and not text ~ "child#"

adjust the JQL as you need for your use case of course.