On Tue, Nov 29, 2011 at 12:41 PM, Bart <b...@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. > -- Bart > > Op 29 november 2011 09:12 schreef Nehmer Torben <torben.neh...@cancom.de> > het volgende: >> >> Good morning, >> >> >> >> I am currently writing a few scripts for internal usage to faciliate some >> Scrum like pattern within RT. One script does create timeLeft Sums on all >> tickets of a given sprint (which is a parent ticket). While all and all this >> works great, I have a little question regarding RT::Ticket: >> >> >> >> The main loop of the script should look for all tickets starting with the >> text “Sprint”, doing about this: >> >> >> >> my $tickets = RT::Tickets->new(RT->SystemUser); >> >> $tickets->LimitQueue( VALUE => $queueName ); >> >> $tickets->LimitStatus( VALUE => 'new' ); >> >> $tickets->LimitStatus( VALUE => 'open' ); >> >> $tickets->LimitSubject( VALUE => “Sprint %”, OPERATOR => 'LIKE' ); >> >> $tickets->OrderBy( FIELD => 'Id', ORDER => 'ASC' ); >> >> >> >> Unfortunalety, the LIKE operation seems to enclose the search pattern into >> wildcards as well, thus finding all tickets which contain the string >> “Sprint” anywhere in the ticket, not just in the subject. >> >> >> >> The operator “STARTSWITH” is not accepted, although specifying STARTSWITH >> in an extended query in RT does yield the expected result. >> >> >> >> Any hints how I can solve this? >> >> >> >> Best regards, >> Torben Nehmer >> >> ------- >> Torben Nehmer >> Diplom Informatiker (FH) >> Business System Developer >> >> CANCOM Deutschland GmbH >> Messerschmittstr. 20 >> 89343 Scheppach >> Germany >> >> Tel.: +49 8225 - 996-1118 >> Fax: +49 8225 - 996-41118 >> torben.neh...@cancom.de >> www.cancom.de >> >> CANCOM Deutschland GmbH >> Sitz der Gesellschaft: Jettingen-Scheppach >> HRB 10653 Memmingen >> Geschäftsführer: Martin Mayr, Tobias Hörmann >> >> Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und >> ausschließlich für den Gebrauch durch den Empfänger bestimmt! >> This e-mail and any files transmitted with it are confidential intended >> solely for the use of the addressee! >> >> >> >> >> -------- >> RT Training Sessions (http://bestpractical.com/services/training.html) >> * Boston — TBA > > > > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston — TBA -- Best regards, Ruslan. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston TBA