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

2016-09-07 Thread Landon Stewart 
On Sep 7, 2016, at 5:01 AM, Keith Creasy 
mailto:kcre...@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?


I'm not sure if this means anything but on my screen the single quotes around 
the word Epic are different than the other words that have single quotes.

'development'
vs
‘Epic’

[cid:B1747A7F-2B3B-409D-9B0F-63C79811C7FC@telus]

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstew...@internap.com
🌍 www.internap.com

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017

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

2016-09-07 Thread Keith Creasy 
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
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