Could you try this condition: $tickets->LimitSubject( VALUE => “*^*Sprint %”, OPERATOR => 'LIKE' );
-- Bart Op 29 november 2011 09:12 schreef Nehmer Torben <[email protected]>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 > [email protected] > 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
