[rt-users] Content search: NOT LIKE

[ktm at rice.edu]

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
> 
> KPN NL


Hi Raymond,

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

Regards,
Ken