[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
> 
> 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



More information about the rt-users mailing list