[rt-users] A question about LIKE

[Liu, Chunyen]

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 at 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20020620/c24769c2/attachment.htm>