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

Keith Creasy kcreasy at aph.org
Wed Sep 7 08:01:27 EDT 2016


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160907/6c46afb8/attachment.htm>


More information about the rt-users mailing list