Re: [rt-users] Custom Field searching

2012-11-09 Thread Ruslan Zakirov
On Fri, Nov 9, 2012 at 10:12 PM, Kristian Davies wrote: >> You don't mention your database. > > Sorry... MySQL 5.1.50-enterprise-gpl-advanced-log > >> Also, please describe "doesn't work". > > By not work I mean it doesn't 'filter out' without the 'IS NOT NULL'. > It does however work with match

Re: [rt-users] Custom Field searching

2012-11-09 Thread Kevin Falcone
On Fri, Nov 09, 2012 at 06:12:12PM +, Kristian Davies wrote: > > Also, please describe "doesn't work". > > By not work I mean it doesn't 'filter out' without the 'IS NOT NULL'. > It does however work with matching on custom fields. What type is your test custom field? You should also be ch

Re: [rt-users] Custom Field searching

2012-11-09 Thread Kristian Davies
> You don't mention your database. Sorry... MySQL 5.1.50-enterprise-gpl-advanced-log > Also, please describe "doesn't work". By not work I mean it doesn't 'filter out' without the 'IS NOT NULL'. It does however work with matching on custom fields. -Kristian We're hiring! http://bestp

Re: [rt-users] Custom Field searching

2012-11-09 Thread Kevin Falcone
On Fri, Nov 09, 2012 at 11:01:04AM +, Kristian Davies wrote: > I'm sure this is a know issue but I can't find a reference to it > (probably looking in the wrong place). > > Version: 4.0.6 > > Works: Queue = 'QueueA' AND CF.{FRUIT} = 'APPLE' > > Does not work: > Queue = 'QueueA' AND CF.{FRUIT