[rt-users] Content search: NOT LIKE

raymond.teunissen at kpn.com raymond.teunissen at kpn.com
Thu May 12 06:52:53 EDT 2016

Hi Ken,

Thanks, but i'm afraid this is not the case. I'm searching in tickets that do not have replies (or comments) at all. The only correspondence is the creation of the tickets (and it's contents). 


-----Oorspronkelijk bericht-----
Van: ktm at rice.edu [mailto:ktm at rice.edu] 
Verzonden: woensdag 11 mei 2016 14:54
Aan: Teunissen, Raymond
CC: rt-users at lists.bestpractical.com
Onderwerp: Re: [rt-users] Content search: NOT LIKE

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