When I run a query for tickets like:
(comment ~ fooString)
... I get the exact set of tickets with fooString in the comments (in my case, there is exactly one. This is good and expected.
But when I search for
(comment !~ fooString)
I get the set of ALL tickets, including the one that contains the string.
Maybe this is because all my tickets have more than one comment, so the expression is matching to one of the comments that doesn't have the string? I'm not sure. But how can I run a query to find all tickets where a string isn't listed anywhere in any of the comments? I'd like to be able to filter out tickets based on comment keywords.
