On Mar 19, 2015, at 8:20 AM, Richard Stevens <[email protected]> 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 130. > > Has anyone observed this type of behaviour?
Hi Richard,
I had this problem just the other day actually. You must enclose CF.{...} in
single quotes when ... has a space in it.
Instead of: CF.{Affected Users}
Do this: 'CF.{Affected Users}'
Also to see what you are looking at in plain text you can visit the full URL
and then change RTIR/Search/Results.html to /Search/Build.html and then click
"Advanced" on the top right. The "Query" box will give you the plain text of
the search you are performing for any given URL.
Landon Stewart : [email protected]
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932
signature.asc
Description: Message signed with OpenPGP using GPGMail
