[rt-users] Search Query Builder Issues (Space Encoding?)

[Landon Stewart]

On Mar 19, 2015, at 8:20 AM, Richard Stevens <piratefrog at 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 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 : lstewart at iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 203 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150319/59576b9c/attachment.sig>