[rt-users] 'content matches' and 'content doesn't match' give same results
alex at peters.net
Fri Aug 8 20:38:21 EDT 2014
Values need to be quoted, I believe. Compare these two queries:
Content LIKE foo.com
Content LIKE 'foo.com'
I wonder whether wildcards might be necessary, like they seem to be in
Content LIKE '%foo.com%'
On 09/08/2014 12:36 am, "Jeff Blaine" <jblaine at kickflop.net> wrote:
> Setup: RT 4.2.5 with PostgreSQL and full-text indexing enabled
> and completed for all tickets. Tickets 1, 2, and 3 all have
> contents with the string foo.com
> Searching for 'content LIKE foo.com' returns tickets 1, 2, 3
> Searching for 'content NOT LIKE foo.com' returns tickets 1, 2, 3
> Has anyone seen this? Any ideas what might be going wrong or how
> do start debugging this?
> Jeff Blaine
> PGP/GnuPG Key ID: 0x0C8EDD02
> RT Training - Boston, September 9-10
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the rt-users