Custom Field searching

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} != ‘APPLE’

Seems to work if I add: AND CF.{FRUIT} IS NOT NULL

Known issue, meant to be like that, is it fixed in a later version?

Cheers,
Kristian

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} != ‘APPLE’

Seems to work if I add: AND CF.{FRUIT} IS NOT NULL

You don’t mention your database.

Also, please describe “doesn’t work”.

-kevin

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

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 checking the web server error logs to make sure
you’re not getting any errors about your query.

-kevin

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.

CF.{X} != ‘apple’ expected to return tickets without value for CF X.
Have I misunderstood you and it actually returns tickets with apple
value?

-Kristian

We’re hiring! Careers — Best Practical Solutions

Best regards, Ruslan.