Thanks Landon,
That was essentially the issue.
On investigation I found some apparent input validation / sanitization in
the RT search function (/opt/rt4/share/html/Search/Build.html) that was not
present in the RTIR search functionality that was wrapping custom fields
with a ' before passing
Thanks Alex,
I had thought it was intermittent, but after some more troubleshooting it
appears that the intermittent is the switch in context between the RT
(works) and RTIR (does not) search pages (if searches are started from
Search--Tickets--New Search) when it identifies the search against an
On Thu, 19 Mar 2015 11:20:51 -0400 Richard Stevens
piratef...@gmail.com wrote:
Hello,
We recently upgrades to RT 4.2.10 / RT-IR-3.2.0 and I'm seeing intermittent
issues on search commands involving custom fields with spaces:
[snip]
The spaces are a red herring. The actual difference is
On Mar 19, 2015, at 8:20 AM, Richard Stevens piratef...@gmail.com wrote:
...
The end result is:
[25773] [Thu Mar 19 14:56:10 2015] [error]: Wrong query, expecting a OPERATOR
in 'Queue = 'Incident Reports' AND CF.{Affected Users}--here LIKE 'frog''
at /opt/rt4/sbin/../lib/RT/SQL.pm line