My query with tilde (~) and NOT operator returns issues with excluded word

[Marina Vasilyeva]

Hello everyone,

I am trying to filter all issues in Resolved status for one project where Comment field does not contain 'passed' word.

I used the next query:

project='my project' AND status=Resolved AND comment !~ "passed"

I tried different variants of query for 'Comment' field  - simple and double quotes, AND NOT operator and !~ but they all return issues containing 'passed' in the comment field.

Please help me to build the correct query.

[Ignacio Pulgar]

Try these steps:

1. Execute this query: comment ~ passed
2. Save that query as a filter named 'Passed'.
3. Clear the issue navigator and execute this query: project='my project' AND status=Resolved AND filter not in (Passed)

Hope it helps.