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<mailto:torben.neh...@cancom.de> www.cancom.de<http://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