Re: [rt-users] Content search: NOT LIKE
On Thu, May 12, 2016 at 10:52:53AM +, raymond.teunis...@kpn.com wrote: > 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 - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
Re: [rt-users] Content search: NOT LIKE
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: k...@rice.edu [mailto:k...@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 LIKE On Wed, May 11, 2016 at 10:43:17AM +, raymond.teunis...@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 - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
Re: [rt-users] Content search: NOT LIKE
On Wed, May 11, 2016 at 10:43:17AM +, raymond.teunis...@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 - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
[rt-users] Content search: NOT LIKE
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 - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
