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' <[email protected]> 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:[email protected]] Sent: Wednesday, September 7, 2016 5:24 PM To: Keith Creasy <[email protected]<mailto:[email protected]>> 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" <[email protected]<mailto:[email protected]>> 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
--------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
