[rt-users] FW: Query for custom fields using 'NOT LIKE' is no longer working

[Keith Creasy]

Apologies. I keep forgetting that replies to this list go to the sender and not to the list…


From: Keith Creasy
Sent: Wednesday, September 7, 2016 5:55 PM
To: 'Hien Ly' <hien.thai.ly at gmail.com>
Subject: RE: [rt-users] Query for custom fields using 'NOT LIKE' is no longer working

Hi. I think I now know the problem but haven’t confirmed it yet.


We just created a new queue for requests submitted by beta testors. It’s sort of an approval queue though we are not using the built-in __approval queue, it’s just a regular queue. A “Type” custom field was created in it with different values from the existing Type field. I suspect that RT is matching the first field with the name CF.{Type} it finds. The reason is that if you use the field id CF.{11} it works.

CF.{11} NOT LIKE ‘Epic’


If this is a solution I’ll let you know but it is equally strange that “LIKE” works while “NOT LIKE” does not.

Is this a bug in RT?


From: Hien Ly [mailto:hien.thai.ly at gmail.com]
Sent: Wednesday, September 7, 2016 5:24 PM
To: Keith Creasy <kcreasy at aph.org<mailto:kcreasy at aph.org>>
Subject: Re: [rt-users] Query for custom fields using 'NOT LIKE' is no longer working


How about NOT (CF.{Type} LIKE 'Epic') ?
On Sep 7, 2016 7:07 AM, "Keith Creasy" <kcreasy at aph.org<mailto:kcreasy at aph.org>> wrote:
Hi everyone.


We are using RT 4.2.7. I think this used to work but now it isn’t. In a query like this:

Queue = 'Nimas' AND Priority > 49 AND (  Status = 'new' OR Status = 'open' OR Status = 'development' ) AND Due > 0 AND CF.{Type} NOT LIKE ‘Epic’


The “NOT LIKE” operator doesn’t work. I’ve tried it using the Query Builder and using Advanced. The “LIKE” operator does work. Does anyone have an idea for solving this?

Thanks.

Keith Creasy, Programmer and Technical Lead
American Printing House f/t Blind
Phone: 502.895.2405<tel:502.895.2405>
Skype: keith537


---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160907/494a997a/attachment.htm>