Searching on CF's not working with RT3.8.6

We have just upgraded from 3.8.2 to 3.8.6 and everything has been fine,
but we have ran into our first problem; when searching on custom fields
it’s ignoring the CF and returning all results.

This is one of the searches we are trying:

Queue = ‘Client Support’ AND Subject LIKE ‘schedule’ AND 'CF.{Client}'
LIKE ‘ClientName’ AND ‘CF.{Client category}’ LIKE ‘Core Client’

Have also tried similar searches without the category. It just returns
all results from the Client support queue with schedule in the subject.

I have just gone through the UPGRADE docs again, and I’m not seeing any
steps I could have missed, so what’s happened?

Thanks,

Alex

We have just upgraded from 3.8.2 to 3.8.6 and everything has been fine,
but we have ran into our first problem; when searching on custom fields
it’s ignoring the CF and returning all results.

This is one of the searches we are trying:

Queue = ‘Client Support’ AND Subject LIKE ‘schedule’ AND 'CF.{Client}'
LIKE ‘ClientName’ AND ‘CF.{Client category}’ LIKE ‘Core Client’

Can you turn on database logging and capture the SQL RT is generating?
(In an ideal world, you could also bring up a copy of your old 3.8.2
instance and do the same thing, but I understand how hard that is)

-j

We have just upgraded from 3.8.2 to 3.8.6 and everything has been fine, but
we have ran into our first problem; when searching on custom fields it’s
ignoring the CF and returning all results.
Works for me, although I’ve not run the upgrade scripts yet since I
have a "3.8.6"
running concurrently with 3.8.1 for testing.

Cambridge Energy Alliance: Save money. Save the planet.

Sorry, my fault, there was a Tickets_Overlay_SQL.pm in the
/opt/rt3/local/lib/RT folder with a line in it to replace
CurrentUserEmail with $self->CurrentUser->EmailAddress.From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: 23 October 2009 18:02
To: Alex Young
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Searching on CF’s not working with RT3.8.6

We have just upgraded from 3.8.2 to 3.8.6 and everything has been
fine,
but we have ran into our first problem; when searching on custom
fields
it’s ignoring the CF and returning all results.

This is one of the searches we are trying:

Queue = ‘Client Support’ AND Subject LIKE ‘schedule’ AND 'CF.{Client}'
LIKE ‘ClientName’ AND ‘CF.{Client category}’ LIKE ‘Core Client’

Can you turn on database logging and capture the SQL RT is generating?
(In an ideal world, you could also bring up a copy of your old 3.8.2
instance and do the same thing, but I understand how hard that is)

-j