<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-GB>Good morning,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>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:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>The main loop of the script should look for all tickets starting with the text “Sprint”, doing about this:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>my $tickets = RT::Tickets->new(RT->SystemUser);<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>$tickets->LimitQueue( VALUE => $queueName );<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>$tickets->LimitStatus( VALUE => 'new' );<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>$tickets->LimitStatus( VALUE => 'open' );<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>$tickets->LimitSubject( VALUE => “Sprint %”, OPERATOR => 'LIKE' );<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>$tickets->OrderBy( FIELD => 'Id', ORDER => 'ASC' );<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>The operator “STARTSWITH” is not accepted, although specifying STARTSWITH in an extended query in RT does yield the expected result.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Any hints how I can solve this?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB style='mso-fareast-language:DE'>Best regards,<br>Torben Nehmer<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;mso-fareast-language:DE'>-------<br>Torben Nehmer<br>Diplom Informatiker (FH)<br>Business System Developer</span><span style='font-size:12.0pt;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;mso-fareast-language:DE'>CANCOM Deutschland GmbH<br>Messerschmittstr. 20<br>89343 Scheppach<br>Germany</span><span style='font-size:12.0pt;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:7.5pt;mso-fareast-language:DE'>Tel.: +49 8225 - 996-1118<br>Fax: +49 8225 - 996-41118<br></span><span style='font-size:12.0pt;mso-fareast-language:DE'><a href="mailto:torben.nehmer@cancom.de"><span lang=EN-US style='font-size:7.5pt;color:blue'>torben.nehmer@cancom.de</span></a></span><span lang=EN-US style='font-size:10.0pt;mso-fareast-language:DE'><br></span><span style='font-size:10.0pt;mso-fareast-language:DE'><a href="http://www.cancom.de/"><span lang=EN-US style='font-size:7.5pt;color:blue'>www.cancom.de</span></a></span><span lang=EN-US style='font-size:12.0pt;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;mso-fareast-language:DE'>CANCOM Deutschland GmbH<br>Sitz der Gesellschaft: Jettingen-Scheppach<br>HRB 10653 Memmingen<br>Geschäftsführer: Martin Mayr, Tobias Hörmann</span><span style='font-size:12.0pt;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:7.5pt;mso-fareast-language:DE'>Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! <br></span><span lang=EN-US style='font-size:7.5pt;mso-fareast-language:DE'>This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!</span><span lang=EN-US style='mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p></div></body></html>