[rt-users] CLI Scripting Question

[Joop]

Ruslan Zakirov wrote:
> On Tue, Nov 29, 2011 at 12:41 PM, Bart <bart at pleh.info> wrote:
>   
>> Could you try this condition:
>>
>> $tickets->LimitSubject( VALUE => “^Sprint %”, OPERATOR => 'LIKE' );
>>     
>
> It wouldn't work. Most times it's easier to use
> $tickets->FromSQL("Queue = 'x' AND (Status ...)") instead of Limit*
> calls. LIKE adding % around arguments is historical thing. Use
> MATCHES.
>
>   
Our use of RT has lead us to patch SearchBuilder to NOT include the % in 
front and back of the search term but to leave it to the enduser the ask 
for wildcard searches. Big bonus: actual use of the indexes.

Joop

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