Question on sql in jira

[mark]

Hello,

I would like to know how to create a filter:

summary does not contain ("a" or "b")

Thanks.

[Nic Brough -Adaptavist-]

The summary field is a text field and hence does not support exact searches, so you can't quite do this.

The closest you can get is with the fuzzy search it does allow - "summary !~ a and summary !~ b" in this case.