[rt-users] Content search: NOT LIKE

ktm at rice.edu ktm at rice.edu
Wed May 11 08:53:58 EDT 2016

On Wed, May 11, 2016 at 10:43:17AM +0000, raymond.teunissen at kpn.com wrote:
> Hi all,
> There seems to be an issue with the contentsearch in RT, or at least, I'm experiencing it :)
> When doing a search like : Queue = 'Queuename' AND Status = 'new' AND Content LIKE 'searchphrase'
> It works.
> When doing a search like: Queue = 'Queuename' AND Status = 'new' AND Content NOT LIKE 'searchphrase'
> It doesn't. It still gives those tickets which have the criteria I specified in the search (and thus don't want to see in the results). Is this a bug perhaps?
> RT4.2.12
> RHEL 6
> Regards,
> Raymond

Hi Raymond,

This search is not doing what you expect. It is finding all tickets that have
at least one reply without the searchphrase.


More information about the rt-users mailing list