[rt-users] Content search: NOT LIKE

[raymond.teunissen at kpn.com]

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). 

Regards,
Raymond

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