A question about LIKE

RT Users
1

I have a need of obtaining results from a query similar to this:
select * from Tickets where Subject like ‘%car%’ or Subject like
‘%color%’

When I browse through the routines ProcessSearchQuery in Web.pm and
_ProcessRestrictions in Tickets.pm, I assume that to get the desired
results,
it is as simple as changing ENTRYAGGREGATOR from AND to OR when
the restriction OPERATOR equals ‘LIKE’. That did not happen.

Did anyone have experience coping with issue?

By the way, I found some possible code issues as follows:
(1) in Tickets.pm, the definition of the associate array %TYPES,
‘Type’ should not appear twice
(2) in the same declaration, it seems ‘Status’ should be ‘STRING’ instead
of ‘ENUM’

Thanks.

Chunyen Liu
chunyen.liu@garmin.com
(913) 3978448 ext 1594

CONFIDENTIALITY NOTE
This email and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies. Thank you for your
cooperation

2

I have a need of obtaining results from a query similar to this:
select * from Tickets where Subject like ‘%car%’ or Subject like
‘%color%’

When I browse through the routines ProcessSearchQuery in Web.pm and
_ProcessRestrictions in Tickets.pm, I assume that to get the desired
results,
it is as simple as changing ENTRYAGGREGATOR from AND to OR when
the restriction OPERATOR equals ‘LIKE’. That did not happen.

What would be useful is an examination of the query as presented to the
SQL server (see the SQL server logs). Quite likely, another
ENTRYAGGREGATOR is being inserted making the query effectively
nonsensical.

chunyen.liu@garmin.com

Your products work btw, except they take an awful long time to resync
after having crossed the atlantic ocean.

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations