Query for custom fields using 'NOT LIKE' is no longer working

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

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 ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com