Content search: NOT LIKE

RT Users
1

Hi all,

There seems to be an issue with the contentsearch in RT, or at least, I’m experiencing it :slight_smile:

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

2

Hi all,

There seems to be an issue with the contentsearch in RT, or at least, I’m experiencing it :slight_smile:

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

3

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@rice.edu [mailto:ktm@rice.edu]
Verzonden: woensdag 11 mei 2016 14:54
Aan: Teunissen, Raymond
CC: rt-users@lists.bestpractical.com
Onderwerp: Re: [rt-users] Content search: NOT LIKEOn Wed, May 11, 2016 at 10:43:17AM +0000, raymond.teunissen@kpn.com wrote:

Hi all,

There seems to be an issue with the contentsearch in RT, or at least,
I’m experiencing it :slight_smile:

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

4

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

Hi Raymond,

I would turn on logging and see what query is actually being used and debug
from there. I have not looked at it lately, but the results were correct in
earlier versions but did not do what I wanted. Let me know what you find.

Regards,
Ken